Deploy-Changes reference script executing without any changes to it

AbelG

Hi all!

We are currently using SQL Change Automation to deploy database changes to our environments. We have reference scripts under the Deploy-Changes folder which we use to insert reference data to our database.

Here's a sample script:

DECLARE @ReferenceTables Utility.ListOfTables

DECLARE @AlternateComparisonColumns Utility.ListOfTablesAndColumns

DECLARE @Administration_UserActivityLogTypes_DATA UserActivityLogTypesTableType
INSERT INTO @ReferenceTables VALUES ('Administration','UserActivityLogTypes')

INSERT @Administration_UserActivityLogTypes_DATA ([ID], [ActivityType])

    VALUES(317, 'DIY Project - Report Access Updated from E4')

INSERT @Administration_UserActivityLogTypes_DATA ([ID], [ActivityType])

    VALUES(318, 'DIY Project - Report Access Published to E4')

DECLARE @SQL nvarchar(MAX) =''

SET @SQL += Utility.GenerateReferenceDataMergeById(@ReferenceTables,@AlternateComparisonColumns)

PRINT @SQL

EXECUTE sp_executesql @SQL

, N'@Administration_UserActivityLogTypes_DATA UserActivityLogTypesTableType readonly'

, @Administration_UserActivityLogTypes_DATA

These reference scripts should only run when there are changes to the file but for some unknown reason, some executes even if there are no changes to the file which causes data issues in production. Is there a known issue/bug in SCA that is similar to this?

Thanks!