Hi there,
when executing an upgrade on a OIM DB, the following error occurs:
Processing step 'QBM StopDBQueueProcessing (Stop DBQueue processing)' failed.
at ConfigWizard.Pages.PageMigration._GenerateSteps()
at Quantum.Migrator.Migrator.GenerateSteps()
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 steps, MigrationContext context)
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context)
227 - Sql command failed.
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context)
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context)
[810023] Error during execution of statement: exec QBM_PWatchDogPrepare @deactivate = 1
at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__14.MoveNext()
[810143] Database error 50000: re-throw in Procedure dbo.QBM_PServerAgentJobDrop, Line 5
at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__14.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadWriteDbSession.<IgnoreBrokenConnectionAsync>d__48`1.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadWriteDbSession.<_SqlExecuteNonQueryAsync>d__15.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__99`1.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__100`1.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.SafeDbCommand.<ExecuteNonQueryAsync>d__16.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext()
[810143] Database error 50000: re-throw in Procedure QBM_PServerAgentJobDrop_i, Line 13
[810143] Database error 50000: re-throw in Procedure QBM_PServerAgentJobDrop_i, Line 7
[810143] Database error 14262: detected in (SRV=IAM-OIM-DB, DB=OneIM) Procedure sp_verify_job_identifiers, Line 41
[810143] Database error 14262: The specified @job_id ('8390E66E-ADCD-4EF8-A84E-C9163DA593B2') does not exist.
Any hint?
Thanks
Dirk