Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Error import bacpac "F...
Finance forum
Suggested answer

Error import bacpac "FINTAG_INSTEADOFINSERTTRIGGER" Error SQL72014 + Error SQL72045

Posted on by 23
Hello,
I have downgraded a database from a Tier1 environment to import it into a TEST VM.
I used the following command powershell to integrate the bacpac:
 
Import-D365Bacpac –ImportModeTier1 –BacpacFile "J:\bacpac\TESTbackup.bacpac" –NewDatabaseName "ImportedDatabase"

And after a few minutes I get the following message :
 
[14:46:33][Invoke-Process] Error output was: \r\n *** Error importing database:Could not import package.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 273, Level 16, State 1, Procedure FINTAG_INSTEADOFINSERTTRIGGER, Line 41 Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.
Error SQL72045: Script execution error.  The executed script:
CREATE TRIGGER [dbo].[FINTAG_INSTEADOFINSERTTRIGGER]
    ON [dbo].FinTag
    INSTEAD OF INSERT
    AS BEGIN
           DECLARE @ErrorLevel AS INT = 0;
           DECLARE @Delimiter AS CHAR;
           DECLARE @IsDelimiterInValues AS BIT;
           DECLARE @ErrorDelimiter AS CHAR = '!';
           SELECT @Delimiter = CASE (SELECT DELIMITER
                                     FROM   FINTAGPARAMETERS
                                     WHERE  PARTITION = (SELECT PARTITION
                                                         FROM   INSERTED)) WHEN 1 THEN '|' WHEN 2 THEN '.' WHEN 3 THEN '_' WHEN 4 THEN '-' WHEN 5 THEN '~' ELSE @ErrorDelimiter END;
           SELECT @IsDelimiterInValues = CASE WHEN CHARINDEX(@Delimiter, concat(TAG01, TAG02, TAG03, TAG04, TAG05, TAG06, TAG07, TAG08, TAG09, TAG10, TAG11, TAG12, TAG13, TAG14, TAG15, TAG16, TAG17, TAG18, TAG19, TAG20)) > 0 THEN 1 ELSE 0 END
           FROM   inserted;
           DECLARE @Hash AS NVARCHAR (64);
           DECLARE @DisplayValue AS N
 
The Tier1 environment and the VM are on version 1.0.0.40 update 64.
• Microsoft Dynamics 365 for Finance and Operations (10.0.40)
• Update64 (7.0.7279.51)

 
On this post https://community.dynamics.com/forums/thread/details/?threadid=39153a38-1518-ef11-9f89-0022481e468e a solution is proposed for version 1.0.0.39 by modifying the model.xml of the bacpac, by removing the element node
 
<Element Type="SqlPermissionStatement" Name="[ Grant.KillDatabaseConnection].[Database].[test]. [Dbo]">…. ….
 </Element>
 
In my model.xml I do not have the element in question.
For the moment I do not have a solution to go back up the database of the Tier1 environment
Do you have a solution to propose to me
Thank you in advance
Sincerely,
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 229,133 Most Valuable Professional on at
    Error import bacpac "FINTAG_INSTEADOFINSERTTRIGGER" Error SQL72014 + Error SQL72045
    Please check out this older thread about the problem: Error in restoring 10.0.39 UAT bacpac file on Development Env.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans