Upgrading database failed
Disabled
After installing the new version RDM (12.6.8.0) upgrading the database fails (from version 12.0.2.0).
The database versions 284 -> 315.
The error:
Cannot find the object "todo" because it does not exist or you do not have permission.
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "Todo" because it does not exist or you do not have permissions.
bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bij System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bij System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
bij System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bij System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bij Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction, IDbDataParameter[] parameters, Int32 commandTimeout)
bij Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)
bij Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)
bij Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)
ClientConnectionId:c8d17dda-e599-4d87-9e0a-ed1ba5200526
Error Number:1088,State:13,Class:16
All Comments (2)
Hello,
The database schema requires an update. Here are the steps to follow;
1. Ask all users to disconnect from the database; either go offline if allowed by your policies, or simply have them change to another datasource
2. Perform a backup of the database
3. In RDM, log in with a user which is also administrator of the SQL database, and perform the upgrade
4. After the upgrade, perform a CTRL-F5 and validate that the sessions are all accounted for. Note that no data is lost, errors may just cause sessions to not be shown.
5. When satisfied, advise users to reconnect, we recommend performing CTRL-F5 to invalidate the local cache.
The process is described in details on https://help.remotedesktopmanager.com/database_upgrade.htm
Best regards,
Jeff Dagenais
Thanx,
I thought i was dbowner on the database. This was a false assumption. After i corrected this the upgrade was succesfull.