Data Deployment Error: FIELD_INTEGRITY_EXCEPTION:field integrity exception

When doing a data deployment, Salesforce may return the following error:

“FIELD_INTEGRITY_EXCEPTION:field integrity exception”

This error generally occurs when you are using a data loader tool to do data migration and you attempt to insert the wrong object ID in destination record’s lookup field.

This is not likely to happen with Copado because Copado maps existing data in source’s fields to the destination fields. 

The more likely scenario for this error to happen with Copado is when a source parameter such as Use Standard Price is enabled in the source Price Book Entry record and then Copado attempts to update a custom price book entry in the destination.

To fix this issue, disable the rule in the source Price Book Entry record, in this case Use Standard Price.

How did we do?