Data Deployment Error: FIELD_CUSTOM_VALIDATION_EXCEPTION:You cannot have multiple time-based Dimensions for the same Product

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

“FIELD_CUSTOM_VALIDATION_EXCEPTION:You cannot have multiple time-based Dimensions for the same Product”

This issue occurs because there is a validation rule that is restricting the Product object to one time-based dimension.

When working with data deployments, it is recommended to ensure any validation rules or triggers you have are valid for your existing data before deploying to the destination org.

If you encounter this issue, you can:
  1. Deactivate the validation rule before deploying the data template and reactivate it once the deployment is completed.
  2. In this particular case, you may want to exclude the offending records.

How did we do?