Error: A duplicate object name has been found

Riccardo

When I run a TeamCity Build I get the following error
Error: A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set.

I'm using the latest versions of the toolbelt in our devs machines and in our TeamCity Agent.
I installed SqlLocaldb 2016. I can see that there is a RedGateTemp instance.
I configured the TeamCity build step to use Sql Server Windows authentication and point to (localdb)\RedGateTemp
I run the TeamCity Agent with the same user that installed sqllocaldb

Please let me know if you need any further information

Following is the detailed error
[11:19:14][Step 1/1] Creating scratch database sqlCI_703c5740-69f5-4dc5-835e-dd520112bd3a
[11:19:14][Creating scratch database sqlCI_703c5740-69f5-4dc5-835e-dd520112bd3a] STARTING: Creating scratch database sqlCI_703c5740-69f5-4dc5-835e-dd520112bd3a
[11:19:15][Creating scratch database sqlCI_703c5740-69f5-4dc5-835e-dd520112bd3a] COMPLETED SUCCESSFULLY: Creating scratch database sqlCI_703c5740-69f5-4dc5-835e-dd520112bd3a
[11:19:15][Step 1/1] Validating database state (19s)
[11:19:15][Validating database state] STARTING: Validating database state
[11:19:15][Validating database state] Starting: C:\TeamCity\buildAgent\plugins\sqlci-teamcity-agent\assets\SC\SQLCompare.exe /include="Identical" /include="StaticData" /scripts1="C:\TeamCity\buildAgent\temp\buildTmp\pjnyurax.bl4\db\state" /server2="(localdb)\RedGateTemp" /database2="sqlCI_703c5740-69f5-4dc5-835e-dd520112bd3a" /synchronize /ignoreparsererrors /options="default,UseMigrationsV2"
[11:19:16][Validating database state] SQL Compare: in trial, expires 28/09/2017 11:02:11
[11:19:16][Validating database state] Automation License: in trial, expires 28/09/2017 11:02:11
[11:19:16][Validating database state] SQL Compare Command Line V10.6.0.1283
[11:19:16][Validating database state] ==============================================================================
[11:19:16][Validating database state] Copyright ¸ Red Gate Software Ltd 1999-2013
[11:19:16][Validating database state]
[11:19:16][Validating database state] Warning: Could not find the file 'RedGateDatabaseInfo.xml' in the scripts folder
[11:19:16][Validating database state] 'C:\TeamCity\buildAgent\temp\buildTmp\pjnyurax.bl4\db\state': the default
[11:19:16][Validating database state] settings will be used instead.
[11:19:17][Validating database state] Registering data sources
[11:19:33][Validating database state] Error: A duplicate object name has been found. This may occur if the SQL Server
[11:19:33][Validating database state] that you are registering is case sensitive but the case sensitive option is not
[11:19:33][Validating database state] set.
[11:19:34][Validating database state] FINISHED WITH ERROR: Validating database state
[11:19:34][Step 1/1] Process exited with code 32
[11:19:34][Step 1/1] Step Build (Red Gate SQL CI Build) failed

Sergio R

Hi Riccardo,

You are using an old version of our DLM Automation tools, as you can see from the log it is using SQL Compare 10.6.0, which does not support SQL Server 2016.

You should use DLM Automation 2 (preferably the very latest version) to work with SQL Server 2016.

Thank you,

DOKMANC2

I was expecting that if I set db comparability to an old version that it would work. It did not