ISSUE: 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
Solution:
We have struggled with a Fintag error while trying to restore the UAT database. We opened a ticket to Microsoft, and thanks to them they showed us how to solve it.
1. Go to Feature Management and turn on the Financial Tags Feature
Thank you will try and update you
ReplyDeleteIssue is resolved with above mentioned details. Thanks for the help
ReplyDelete