DB Upgrade error

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

Parents
  • Hi Dirk,

    this happens when you start your migration with a SQL Server login that is not the owner of the SQL Server Agent Jobs. The owner of the SQL Agents should be the same as the database owner.

    Might be someone dropped and recreated the SQL Agent jobs as sa while your OneIM installation has its own SQL Login.

    regards

    Andreas

Reply
  • Hi Dirk,

    this happens when you start your migration with a SQL Server login that is not the owner of the SQL Server Agent Jobs. The owner of the SQL Agents should be the same as the database owner.

    Might be someone dropped and recreated the SQL Agent jobs as sa while your OneIM installation has its own SQL Login.

    regards

    Andreas

Children