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
imAkashGargimAkashGarg 

URGENT: Foreign key external ID not found

Salesforce is integrated with Cordys. The new registrations(accounts) are coming to SF from Cordys, with a unique GUID. Now, the orders associated with the accounts are coming to SFDC from cordys. Most of the orders are successfully pushed to SF but some of them fail, getting an error in Cordys as:

 

    Foreign key external ID: 300111468 not found for field Customer_GUID__c in entity Account

 

from the error i believe the registrations fail to come in SF which lead to order failure.

what could be the reason for this failure??

 

Need Help.

Best Answer chosen by Admin (Salesforce Developers) 
IspitaIspita

Hi,

The failure can be due to anything- ranging from :-

  • unexpected error during record creation
  • not providing a required field 
  • Providing data in  format which is not acceptable
  • Time out during record creation

I suggest you add logging of error to do a proper analysis of the error encountered.

 

Hope this helps...

All Answers

IspitaIspita

Hi,

The failure can be due to anything- ranging from :-

  • unexpected error during record creation
  • not providing a required field 
  • Providing data in  format which is not acceptable
  • Time out during record creation

I suggest you add logging of error to do a proper analysis of the error encountered.

 

Hope this helps...

This was selected as the best answer
UVUV

You are pusing account data in salesforce and error is telling you that there is no such row with value "300111468 " for field "Customer_GUID__c" under Account. So there is no match for the id-300111468

imAkashGargimAkashGarg

Thanks.

There was a field format mismatch for some of the values coming from cordys.