Dynamics Community Forum Thread Details

FINTAG_INSTEADOFINSERTTRIGGER, Cannot insert an explicit value into a timestamp column.

Hello Everyone,

This is my first post. I am a little exited :)

We have struggled with Fintag error while trying restore UAT database. We opened a ticked to Microsoft thanks to them they show us how to solve it. We would like to share with community.

Go to Feature Management and turn on the Financial Tags feature.
Go to the Data maintenance portal and click /Check for updates/.

Run the /Deploy financial tag table triggers/ data maintenance job (Clicking on including system action):

When the job finishes successfully, you can take a new export database and then try to load that one into the development environment.

Command prompt error message

After I did those step above I got a new error like below. You can find the solution that I got from Microsoft

With the Kill SQL connection issue, please help me to follow the below steps very carefully:

Convert your bacpac file to .zip (just edit the file extension and change .bacpac to .zip)
Copy the file model.xml from the zip folder to some location.
Revert back the .zip to .bacpac
Now edit the model.xml file (the copy) and find the SqlPermissionStatement(see image) "Grant.KillDatabaseConnection" element and remove the whole <Element>...</Element> from the xml file and save it.

While using the sqlpackage.exe import action, add /mfp:"YourCopiedModel.xmlPath" to the commands, this will allow you use the edited model.xml instead of original one in the bacpac.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL