Forum Discussion
Salesforce data load stops at 128001
I try lo load the Account table and it stops at 128.001 with one error (I've seen there is another post with the same problem). If I refer to the same query, I can get different numbers: -- 128....
Generally when I have run into similar issues it comes down to some bad data. I had similar issues with certain fields in Microsoft CRM when loading Leads. That being said, it looks like you are only loading a single field so you can't get around it like I did by removing fields. What is the error?
How can I see the error? I only see " loaded x rows with 1 error"
Anonymous - Probably the best thing to do would be to turn on logging. Go to File | Options & Settings | Options | Diagnostics and check the box to enable Tracing. Run the data load and then take a look at the trace file.
Anonymous Can you run the following query:
= Table.SelectRowsWithErrors(PreviousStep)
- DataSource.Error: The operation has timed out Details: https://my.salesforce.com/services/data/v29.0/query/01g2000002x2iwbAAA-128000
Not sure how you are connecting into Salesforce.com but be aware that Salesforce.com has execution Governors and Limits to prevent performance issues. It is quite possible that Salesforce.com connectivity is telling you that you are limited in the data you can extract.
Check out the url below for more info.....
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
Diana
