SqlCompare plugin fails File not Found message
Answered
We are using TeamCity 9.1.5 in Professional mode. We use Redgate DLM automation 2.0.30. Our VCS is Git. We use Redgate Sql Source Control. Our build configuration fails with the following log (relevant portion). How can I find out what file is not found or increase the logging level?
[01:00:47][Step 1/3] Validating database state (40s)
[01:00:47][Validating database state] STARTING: Validating database state
[01:00:47][Validating database state] Starting: E:\TeamCity\buildAgent\plugins\dlmautomation-teamcity-agent\assets\SC\SQLCompare.exe /include="Identical" /include="StaticData" /scripts1="E:\TeamCity\buildAgent\temp\buildTmp\SQL CI\tlq5vj1v.c5d\db\state" /server2="clarity-sql2012.cloudapp.net" /database2="sqlCI_49a5a8fd-e38f-45c0-acd1-30125f0b829d" /username2="sa" /password2=****** /synchronize /tempInstance=****** /options="DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IncludeDependencies,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName,UseCompatibilityLevel,UseMigrationsV2"
[01:00:48][Validating database state] Automation License: activated, edition: standard, serial number: 048-001-192112-A79E
[01:00:51][Validating database state] SQL Compare Command Line V11.6.2.1799
[01:00:51][Validating database state] ==============================================================================
[01:00:51][Validating database state] Copyright Copyright c 1999 - 2016 Redgate Software Ltd
[01:00:51][Validating database state]
[01:00:54][Validating database state] Registering data sources
[01:01:12][Validating database state] Creating mappings
[01:01:13][Validating database state] Comparing
[01:01:14][Validating database state]
[01:01:14][Validating database state] Applying Command Line Items
[01:01:14][Validating database state]
[01:01:18][Validating database state] Checking for identical databases
[01:01:18][Validating database state] Creating SQL
[01:01:25][Validating database state] Error: Comparison of 'Scripts.state' and
[01:01:25][Validating database state] 'clarity-sql2012.cloudapp.net.sqlCI_49a5a8fd-e38f-45c0-acd1-30125f0b829d'
[01:01:25][Validating database state] failed: Cannot apply: File not found
[01:01:27][Validating database state] ##teamcity[buildStatus status='FAILURE' text='Validating database state failed with error: SQLCompare failed with exit code 126: see output above for more information, or for generic information about this exit code, see: http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare';]
[01:01:27][Validating database state] FINISHED WITH ERROR: Validating database state
Please sign in to leave a comment.
Hello Richard,
Do you use a third party plugin? If yes, please contact plugin's developer(s).