Share
Report
25Hello,
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:
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
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)
• 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>
</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,
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,
All responses (
Answers (
