Dynamics Community Forum Thread Details

Failed to import bacpac into the VM. Error SQL72014

Hello,
For several days, I haven't been able to restore a database from a tier 2 to a tier 1 environment.

The production environment is running version 10.0.40, and the VM is also on version 10.0.40.

I am using the following command with PowerShell in Admin mode:

Import-D365Bacpac -ImportModeTier1 -BacpacFile "J:\bacpac\preprodbackup.bacpac" -NewDatabaseName "ImportedDBV2"

I get the following message:

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

WARNING: [13:30:50][Invoke-Process] Stopping because of Exit Code. | Stopping because an Exit Code from SqlPackage.exe
wasn't 0 (zero) like expected.
[13:30:50][Invoke-SqlPackage] The SqlPackage.exe exited with an error.
WARNING: [13:30:50][Invoke-SqlPackage] Stopping because of errors.

Could you please help me?

Thank you.

Quick Links