I'm on my Devolutions Server Console any time I try to save some thing I'm now getting this. Doesn't matter what it is new role, group user all seems to give the same error.
Last time I tried to do something it was working but that was before I applied the v13 update to the DB. I'm running the latest RDM as well.
Accessing the repository, adding and saving stuff seems to work from RDM. Only seems to be on the server console I have the issue.
The test server in server settings -> database comes up successful as does the test database button. Database version says its 377
Any ideas?
Craig
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'HasAccessRDM'.
Invalid column name 'HasAccessPVM'.
Invalid column name 'HasAccessWeb'.
Invalid column name 'HasAccessWebLogin'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, 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& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction, IDbDataParameter[] parameters, Int32 commandTimeout)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseSecuritySubDataSource.InsertUserSecurity(UserEntity user, IDbTransaction dbTransaction)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseSecuritySubDataSource.UpsertUserSecurity(UserEntity user, IDbTransaction dbTransaction)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.c420570cc362838b38ecc18ba825950e5(UserEntity cf98b881282579a38f0d3820b4755fa4a, Boolean cd589fb599494638c495afc5cf9b2449e, String ceb81d1ee93f91e0bc57f34876c263863, SaveUserInfoAdvancedCustomData ca846991ced5070300e1c8ec384f436f9, Guid[] cf090f8a8f0907c3009c224a9172cab64)
ClientConnectionId:4cf5b48d-cc02-4266-a289-e51d012a704c
Error Number:207,State:1,Class:16
Hello Craig,
With the information given, I think you are running DVLS 4.6.0 or 4.6.1 with RDM v13, but RDM v13, need to run with DVLS 4.7.0. That being said, prior to do an DVLS update I suggest to send us an email to support@devolutions.net. So we could do with you the DVLS update and be sure no problem will be related.
Do you have any backup of the database to revert back to the previous version?
For information RDM V13 is running with DVLS 4.7 with schema v.1.386.
Best regards,
David Grandolfo
Thank you, That sounds like what it is, I'm away from our office for the next few days so I'll look in to it when I get back.
Hello. As we are only trialing it at the moment, I went ahead and did the update myself.
This resolved the problem.
Thanks again,
Craig
Hello,
Thank you for getting back to us! I'm glad to hear it works.
Best regards,
Érica Poirier