SOLVED

Re: SFDC Sync error Failed: INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY: insufficient access rigts on the cross-reference id

Go to solution
ChristineT
Level 2

SFDC Sync error Failed: INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY: insufficient access rigts on the cross-reference id

Hi,

Does anyone know what this error message means. Is this something we need to address or will this be ok in the next sync?

 

Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: SFDC Sync error Failed: INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY: insufficient access rigts on the cross-reference id

@ChristineT, This error indicates that the user account used for Marketo's Salesforce synchronization lacks the necessary permission to access and update a specific cross-reference field or its linked record in Salesforce. Cross-reference fields, such as lookups or master-detail relationships, connect records across different objects.

 

Potential things to check:

  • Insufficient User Permissions (most likely): The user account used for the Marketo-Salesforce sync might not have sufficient read or write access to the relevant object, field, or related record.
    • In Salesforce, ensure the API user account has read/write access to the object, field, and related record in question.
    • Double-check that the user has appropriate object-level security and field-level security permissions.
  • Inactive or Deleted Records: If the cross-reference field references a record that is inactive or deleted in Salesforce, the sync will fail due to nonexistent data.
  • Record Type Mismatch: If your Salesforce instance uses record types and the API user's permissions are limited to specific types, the error might occur if the target record has a different record type.
    • If record types are used, ensure the API user has access to the specific record type of the target record.
    • Adjust permissions or mapping configurations if necessary.
  • Apex Trigger Interference: If you have custom Apex triggers on the object involved, they might be interfering with the synchronization process and causing access issues.
  • Sharing Rules and Ownership: Sharing rules and ownership restrictions in Salesforce might prevent the API user from accessing or updating certain records.

Lastly, it's crucial to address this error promptly as it indicates unauthorized access or potential data integrity issues, and this is not a type of error that will get fixed on its own next time the record syncs.

View solution in original post

2 REPLIES 2
uditmathur
Level 5

Re: SFDC Sync error Failed: INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY: insufficient access rigts on the cross-reference id

Hi ChristineT,

This error indicates that the user updating does not have sufficient access to update SFDC.

these links can help understanding & trouble shooting.

https://nation.marketo.com/t5/knowledgebase/sfdc-sync-error-insufficient-access-on-cross-reference-e....

 

https://experienceleague.adobe.com/docs/marketo/using/product-docs/marketo-sales-connect/crm/salesfo...

 

Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: SFDC Sync error Failed: INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY: insufficient access rigts on the cross-reference id

@ChristineT, This error indicates that the user account used for Marketo's Salesforce synchronization lacks the necessary permission to access and update a specific cross-reference field or its linked record in Salesforce. Cross-reference fields, such as lookups or master-detail relationships, connect records across different objects.

 

Potential things to check:

  • Insufficient User Permissions (most likely): The user account used for the Marketo-Salesforce sync might not have sufficient read or write access to the relevant object, field, or related record.
    • In Salesforce, ensure the API user account has read/write access to the object, field, and related record in question.
    • Double-check that the user has appropriate object-level security and field-level security permissions.
  • Inactive or Deleted Records: If the cross-reference field references a record that is inactive or deleted in Salesforce, the sync will fail due to nonexistent data.
  • Record Type Mismatch: If your Salesforce instance uses record types and the API user's permissions are limited to specific types, the error might occur if the target record has a different record type.
    • If record types are used, ensure the API user has access to the specific record type of the target record.
    • Adjust permissions or mapping configurations if necessary.
  • Apex Trigger Interference: If you have custom Apex triggers on the object involved, they might be interfering with the synchronization process and causing access issues.
  • Sharing Rules and Ownership: Sharing rules and ownership restrictions in Salesforce might prevent the API user from accessing or updating certain records.

Lastly, it's crucial to address this error promptly as it indicates unauthorized access or potential data integrity issues, and this is not a type of error that will get fixed on its own next time the record syncs.