Share
Report
6Hello 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.
All responses (
Answers (
