function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
LimesLimes 

Dataloader results bug?

I am running the Lexi Data Loader on a Mac.  (Though I'm not sure that this is the differentiator in this issue).

I have been able to replicate a scenario where I am inserting new contacts using BulkAPI in serial or parallel mode and get a "corrupt" success file back.

 

In my list of contacts I know (based partially on error returned by the data loader) that I have some "bad" Date-of-Birth data.

I get "Error converting value to correct data type: Date Conversion FAILED" returned in the error file.  And thats ok, I understand why.

 

However the SAME records ALSO are returned in the success file.  And they have ID's assigned.  And after this record each ID assigned to subsequent records is skewed by 1 row.  For example It generates a success file like the following

 

ID                                          Name

003A000000MY64aIAD        Joe-bad-DOB  (who shouldn't be in the success file?)

003A000000MY64bIAD        Bob Jones

003A000000MY64cIAD        JIm Smith

 

but if I paste the Bob Jones id in the url in Salesforce, up comes the Jim Smith record.

 

The skew gets worse (by 1) each time one of these errors is detected. And as far as I can tell its ONLY this specific error that causes this behavior. 

Since one typically uses these success files to create other related objects it can really screw up your data (for instance I was creating relationships to other contacts, which ended up relating totally wrong people).  And was hard to catch in a dataset of 50,000 contacts.  Kinda frustrating if I can't trust the tool (or is it I can't trust me?)

 

I've been doing SFDC dataloading about 2 months.

 

So....bug or user error?  If bug, Salesforce or Lexi?

 

I expect the replication steps to be:

Setup 5 contact records for insert

Put bogus DOB info in the 2nd row to evoke the error.

See if the id's returned for rows 3-5 are "really" their id's.  I'd have done this but all the investigation put me over the "batches / 24 hour" limit....so i"m using the time to post. :)

 

Obviously I'm going to just fix or not map my DOB data for this run to get by this.....but it scares me a little and it burned 12hrs of my time finding it.   More seasoned insight welcome.

 

dave

 

 

 

LimesLimes

I've sucessfully replicated this behavior, following my own replication steps posted, into a clean developer org using 4 contact record inserts. 

I'm using LexiLoader v 17 (latest available)  on a Mac 10.6.4  and Excel 2008 for Mac.

 

I've asked a consultant we work with to see if it replicates on Windows using the "standard"  dataloader.