Invalid column name 'remote_data_archive_migration_state'
TobiasO
Posts: 3
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:
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:
Are you aware of this issue, and is there a way to resolve this.
Thank you very much.
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.tablesThe following query
SELECT (@@microsoftversion / 0x1000000) & 0xff AS VersionMajor, (@@microsoftversion / 0x10000) & 0xff AS VersionMinor, @@microsoftversion & 0xffff AS BuildNumber SELECT SERVERPROPERTY('productversion') AS ProductVersionreturns 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
Support for SQL Server 2016 was added in V1.7.5, to download this version please download using the link below:
ftp://support.red-gate.com/patches/DLMD ... hboard.zip
Would you please upgrade and confirm if you are still experiencing the reported problem.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Thank you for your reply.
I ran the update you provided, and now the problem is resolved.
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com