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
Alexis RodriguezAlexis Rodriguez 

Data Migration using Talend: Salesforce 18-chars Id reported in lower case

Hello Everybody,

I am facing a weird behavior with talend. I am trying to migrate events using talend bulk components. I have migrate 99% of the data, but for the few left records, i get the following error:

INVALID_FIELD:Foreign key external ID: 0032000001ucgknaah not found for field Sandbox_Migration_Id__c in entity Contact:--

As you can see, it's reporting the lower case of the actual id of the contact.

I'm puzzled because it worked for most of the records except for few. Does anybody have a clue about this?

thx
ShashankShashank (Salesforce Developers) 
You might want to check how the external Id field is being populated in the first place.