Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
Sqlpackage import is failing when importing a BACPAC file from a T2 environment, resulting in an error related to inserting an explicit value into a timestamp column.
Reason:
This is due to new changes that allow row version tracking for the Fintag table. This table uses an INSTEAD OF INSERT trigger, which may be incompatible between the versions to which data is being transferred.
Resolution:
- Upgrade the production instance to the same version as the sandbox.
- Install the target environment to the same version as production, and then perform the upgrade on UAT after data movement.
- If the instance is on the required version, enable the financial tags feature in feature management, then access the data maintenance portal and run the "Deploy financial tag table triggers" action. After completing this, the error should no longer occur.
- Review the compatibility matrix to identify the appropriate scenario for importing the BACPAC file.