Forum Discussion
Anonymous
10 years agoNot applicable
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....
Greg_Deckler
10 years agoCommunity Champion
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?
- Anonymous10 years agoNot applicable
How can I see the error? I only see " loaded x rows with 1 error"
- Greg_Deckler10 years agoCommunity Champion
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.
- pqian10 years agoMicrosoft Employee
Anonymous Can you run the following query:
= Table.SelectRowsWithErrors(PreviousStep)
- Anonymous10 years agoNot applicableDataSource.Error: The operation has timed out Details: https://my.salesforce.com/services/data/v29.0/query/01g2000002x2iwbAAA-128000