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
trick9trick9 

Data loader Problem

 

Hi Guys,

 

Can u please tell me what would the below given error means?.Please elaborate as much as possible on the erorr.Any examples are most welcome.

 

Foreign key external ID: 00011063727461035506 not found for field DST_Contact_Id__c in entity Contact

Thanks,

Trick9

Best Answer chosen by Admin (Salesforce Developers) 
Starz26Starz26

it means there is no DST_Contact_ID__c with the value of 00011063727461035506.

 

 

All Answers

Starz26Starz26

It means that there is no Contact with the ID of - 00011063727461035506

 

that number is not a salesforce ID, are you using a custom field for the Contact ID?

trick9trick9

Thanks for the reply.

 

I am using custom field which is an external ID field.This is actually an integratted prioject and the project is having lot of issues So I am looking at those issues

 

Command line interface data loader has been used to migrate records into the salesforce system. I was looking at the success and error files so I came across an error file with this error.

 

So when u say there is no contact with the below given id.What does it mean.It means that there is no Contact with the ID of - 00011063727461035506.

 

How does this external id  concept should have worked while migrating records into the salesforce through command line interface?

 

 

 

 

Starz26Starz26

it means there is no DST_Contact_ID__c with the value of 00011063727461035506.

 

 

This was selected as the best answer
trick9trick9

 

Thanks once again .

So it means that while migrating records through the data loader to the contact object it expects 00011063727461035506 id to be there in the contact object.Since it is not there therefore It gives an error.

 

Please correct me if I am wrong?

 

Thanks,

Trick9 

 

Starz26Starz26

As I am reading it Yes, it expects there to be a contact record with the DST_Contact_ID__c = 00011063727461035506

trick9trick9

 

Thanks a lot,

I wish I could email you the EXCEl file with the errors in it to have more clarity

.

Through data loader we can do 3 Things

We can either Insert,delete and update records.

 

As far as my problem is concerned I am getting External ID error.So it means here we are doing upsert operation.The upsert operation works if the record doesn't exists in the salesforce database, salesforce inserts it if it already exists in the database then it upates the record.

 

So it looks like it should have inserted the record into the system instead of creating an error.

 

 

Thanks,

Trick9