Dynamics Community Forum Thread Details

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

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,