INVALID_CROSS_REFERENCE_KEY

An error appears in the Job details during a Salesforce restore operation.

Symptoms

One of the following errors appear in the Job details during a restore operation:

• AccountContactRelation record 07k3z000006wTCcAAM was not inserted. Error code:INVALID_CROSS_REFERENCE_KEY; Error message: You can't associate a private contact with an account. Here is the explanation from Salesforce https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A939qSAB
• 2022-03-10 16:24:14,973 ERROR [SalesforceConnector] 3361989 restoreFailure(insert:351) - Asset record 02i3z00000XD6kTAAT was not inserted. Error code:INVALID_CROSS_REFERENCE_KEY; Error message: Record Type ID: this ID value isn't valid for the user: 0123z000000OGncAAG

Causes

The user profile that is configured for backup or restore does not have the correct record type (id 0123z000000OGncAAG )  assigned to the Asset object. Please go through the link to set it.

Resolution

Do the following steps to enable the RecordType on SFDC:

1. Log on using a System Administrator profile on SFDC.
2. Click Setup under the username on SFDC.
3. Click Manage Users under Administrative Setup section
4. Enter the profile that needs to be added to. To enter, click the profile but do not click on Edit
5. Scroll down to the* Record Type Settings *section and click edit for the Asset object. Select the specific record type in the list Available Record Types and add it to Selected Record Types.
6. Save the changes.