Share
Report
1,860Hi, I'm getting below error while trying to restore 10.0.39 UAT.bacpac on development environment (10.0.39)
Procedure FINTAG_INSTEADOFINSERTTRIGGER, Line 41 Cannot insert an explicit value into a timestamp column
Anyone faced this same issue and found a resolution from MS Support?
Importing to database 'UATDBApr' on server 'localhost'.
Creating deployment plan
Initializing deployment
Verifying deployment plan
Analyzing deployment plan
Importing package schema and data into database
Updating database
.//SqlPackage.exe : *** Error importing database:Could not import package.
At line:1 char:1
+ .//SqlPackage.exe /a:import /sf:C://Users//localadmin//Downloads//21Apr24. ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (*** Error impor...import package.:String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError
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
Time elapsed 0:14:17.66
Creating deployment plan
Initializing deployment
Verifying deployment plan
Analyzing deployment plan
Importing package schema and data into database
Updating database
.//SqlPackage.exe : *** Error importing database:Could not import package.
At line:1 char:1
+ .//SqlPackage.exe /a:import /sf:C://Users//localadmin//Downloads//21Apr24. ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (*** Error impor...import package.:String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError
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
Time elapsed 0:14:17.66
All responses (
Answers (
