Invalid column name 'remote_data_archive_migration_state'

TobiasOTobiasO Posts: 3
edited March 23, 2017 4:55AM in DLM Dashboard
Hello people of Redgate,

First of all let me tell you that your products are very nice, thank you for that.
Now unfortunately something is broken.

The way of authentication is SQL user, and from the same machine in Microsoft SQL Studio Management Studio 2014 the machine is able to make a connection and do some select on the available databases in there.
When adding a new database in the DLM Dashboard (DLM Dashboard 1.7.4.1062) 2 tables are created, and 3 Stored Procedures inside the RedGate Database.
The interface also sees all databases that are on that database server.
The following things are also possible for this user:
SELECT * FROM sys.sql_expression_dependencies
 SELECT * FROM sys.tables
The following query
SELECT
(@@microsoftversion / 0x1000000) & 0xff AS VersionMajor,
(@@microsoftversion / 0x10000) & 0xff AS VersionMinor,
@@microsoftversion & 0xffff AS BuildNumber

SELECT SERVERPROPERTY('productversion') AS ProductVersion
returns VersionMajor 13 VersionMinor 0 BuildNumber 4199
ProductVersion: 13.0.4199.0

As I read somewhere on this forum there could be an issue with Azure SQL. But that is not the case here.

In C:ProgramDataRed GateLogsDLM DashboardRedGate.SQLLighthouse.SQLServerMonitoringService-1.7.4.1062-20170316-S-1-5-20.log
there is the following error:
2017-03-16 17:01:42.774 +01:00 [Information] Taking snapshot of "DbConfigs-130"
2017-03-16 17:01:43.556 +01:00 [Warning] Couldn't take a snapshot, because DLM Dashboard couldn't connect to the SQL Server.
RedGate.SQLLighthouse.SQLServerMonitoringService.ChangeNotification.SqlServerUnavailableException: Unable to snapshot database ---> System.Data.SqlClient.SqlException: Invalid column name 'remote_data_archive_migration_state'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at RedGate.SQLCompare.Engine.Registration.ReadFromSql.LiveDMVModel.DoQuery(String strSql)
   at RedGate.SQLCompare.Engine.Registration.ReadFromSql.LiveDMVModel.Table()
   at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.PopulateTables(DBPopulationOptions popOptions)
   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)
   --- End of inner exception stack trace ---
   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)

Are you aware of this issue, and is there a way to resolve this.
Thank you very much.

Comments

Sign In or Register to comment.