Salesforce Loading issue.

[abhi2636]

Hi experts,

We are trying to load  data from Open hub destinations to Salesforce.

The job is running successful but only 200 records are getting loaded to Salesforce target instead of all 1400 coming from ohd source.

I hope this is happening because batch size for salesforce in DS is 200 by default.

And also in the error log it is showing error for CreatedById column as below in different scenarios:

When I map default value for the column Its throwing below error:

                                

When I map unique values for the column (using gen_row_number()) its throwing below error:

                                

When I map with blank its showing below error:

                              

Can any one please help me out of this.

Is there any option need to be specified at salesforce.com side to load all the records to salesforce instead of only 200?

Appreciate quick responses.

Thanks in advance

[abhi2636]

Hi Can any one please suggest a solution on this. Its very urgent.

[former_member184566]

Hi Abhi

The error messages you see in DS are sent either from source or target. These errors are coming from your target which is SalesForce. So should check with Salesforce.

If I had to guess or troubleshoot, to me it sounds like you trying to populate a field CreatedBy and Salesforce is trying to validate that the user exists in Salesforce for that org.

Try loading again, but hard code the CreatedBy column with a username that you know exists in Salesforce for that org.

Hope this helps.