[Error] Failed while taking a snapshot.

henrik_ffc

Hi,

I am getting a "A duplicate object name has been found"-error. Perhaps because the database is case sensitive, so how do I switch on the "case sensitive option"?

The affected databases are stuck at "Checking schema..."-state on the DLM dashboard

Error details:
2017-11-27 11:17:07.585 +01:00 [Information] "DbConfigs-18" needs to be checked.
2017-11-27 11:17:07.589 +01:00 [Information] Taking snapshot of "DbConfigs-18"
2017-11-27 11:17:08.101 +01:00 [Error] Failed while taking a snapshot.
RedGate.SQLCompare.Engine.SqlCompareException: 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. ---> System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at RedGate.SQLCompare.Engine.KeyedCollection`1.Add(T value)
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.PopulateDdlTriggers()
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.Populate(DBPopulationOptions popOptions)
--- End of inner exception stack trace ---
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.Populate(DBPopulationOptions popOptions)
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.RegisterFromLive(Database database, ConnectionProperties connectionProperties, Options options, IDmvModelFactory factory)
at RedGate.SQLLighthouse.SQLServerMonitoringService.Snapshotting.SqlCompareDatabaseCreator.DatabaseFromDbConfig(DbConfig dbConfig)
at RedGate.SQLLighthouse.SQLServerMonitoringService.Snapshotting.DbObservationCreator.CreateDbObservationOfDatabase(DbConfig dbConfig)
at RedGate.SQLLighthouse.SQLServerMonitoringService.Snapshotting.SnapshotTakingObserver.GetObservationOfDatabase(DbConfig dbConfig, IDbObservationCreator dbObservationCreator)
at RedGate.SQLLighthouse.SQLServerMonitoringService.Snapshotting.SnapshotTakingObserver.TakeSnapshot(DocumentReference`1 dbConfigRef, DbObservationRecordingService dbObservationRecordingService, IDbObservationCreator dbObservationCreator, IDocumentSession session)
at RedGate.SQLLighthouse.SQLServerMonitoringService.Snapshotting.SnapshotTakingObserver.<>c__DisplayClass4_0.<OnNext>b__0(IDocumentSession session, DbObservationRecordingService service, IDbObservationCreator snapshotCreator)
at RedGate.SQLLighthouse.StorageCore.UnitOfWorkFactory.Within[T1,T2,T3](Action`3 func)
at RedGate.SQLLighthouse.SQLServerMonitoringService.Snapshotting.SnapshotTakingObserver.OnNext(DbNeedsCheckingEvent checkEvent)

henrik_ffc

BTW: The affected databases are stuck at "Checking schema..."-state on the DLM dashboard

way0utwest

I'm not sure where this is set, but I've passed a note along to support. They should respond soon.

Jessica R

Hi @henrik_ffc,

This might actually be a permissions issue. Can you please first make sure you have the appropriate permissions, listed here: https://documentation.red-gate.com/ddb1/getting-started/creating-a-login-with-the-correct-permissions ?