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

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,

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.

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,

Hello again,

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

Best regards,