Forum / Remote Desktop Manager - Bug Report

An object with the name already exists in the database "PAMIsInList"

  • Create an Issue
  • Cancel


System.Data.SqlClient.SqlException (0x80131904): An object with the name already exists in the database "PAMIsInList".
в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
в System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
в System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
в System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
в Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction, IDbDataParameter[] parameters, Int32 commandTimeout)
в Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)
в Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(IDatabaseUpdater updater, BaseUpdater scripts)
в Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseUpdater.Upgrade(Boolean silent, Action`1 logMessage)
ClientConnectionId:fe28435c-c67b-474d-9657-7ce2dfcd8c8e
Error Number: 2714, State: 3, Class: 16

How to fix? Login is carried out under the administrator

Clock4 mths

Hello,

Are you trying to install RDM 2019.2.14.0 or 2019.2.15.0?

You are running a SQL Server data source right?

Best regards,



Jeff Dagenais
signaturesignature

Clock4 mths

Hi Everyone,


we're having the exact same issue in our firm. Multiple attempts when upgrading the Database from version 563 to 575 fail with the error given above.


System.Data.SqlClient.SqlException (0x80131904): In der Datenbank ist bereits ein Objekt mit dem Namen 'PAMIsInList' vorhanden.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
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.DatabaseConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)
at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(IDatabaseUpdater updater, BaseUpdater scripts)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseUpdater.Upgrade(Boolean silent, Action`1 logMessage)
ClientConnectionId:bfe4682b-886c-47ad-8d55-e38fe2a9192e

Error Number:2714,State:3,Class:16


Also, either the German or English translation is incorrect. The German claims that an object with the name PAMIsInList is already present in the DB and the English claims that "an object" within the DB PAMIsInList already exists.

Clock4 mths

Hello,

We would need your schema to troubleshoot this error.

In RDM 2019.2.15.0, go in File -> Data Sources -> Upgrade tab -> Email Schema to Support to send us the schema.

Let me know when it's done.

Best regards,



Jeff Dagenais
signaturesignature

Clock4 mths

Hello again,

We may have found something concerning this issue. Could you try the following steps?

  • Close RDM
  • Download the zip file in attachment to this post
  • Extract the dll file in the installation folder of RDM
  • Restart RDM
  • Complete the database upgrade

Best regards,



Jeff Dagenais
signaturesignature

Devolutions.DatabaseUpgrade.zip
Clock4 mths