Hi.
When in-place upgrade procedure is performed then ActiveRoles creates a new database each time ?
When I change current database I get the error -
[InsertArServiceRecord] :Error Generated. Details: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_ARServices_objectGUID'. Cannot insert duplicate key in object 'dbo.ARServices'. The duplicate key value is (46081a84-c894-413a-9fcc-0fcc5311ead1).
The statement has been terminated.
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 ActiveRoles.Service.Configuration.Database.UpdateDatabaseAction.InsertArServiceRecord(DatabaseParameters dbConnection, String SourceDb, String DestinationDb)
ClientConnectionId:ef4a6431-3193-4187-81b3-b451cf359b26
Error Number:2627,State:1,Class:14
[Error] [ArsBaseCommand.ProcessRecord]: Violation of PRIMARY KEY constraint 'PK_ARServices_objectGUID'. Cannot insert duplicate key in object 'dbo.ARServices'. The duplicate key value is (46081a84-c894-413a-9fcc-0fcc5311ead1).
The statement has been terminated.
What am I doing wrong?
