Hi,
OneIM Version 8.2.1
I have newly installed oneIM on the production server. Now I'm getting below error. I think there was no such error before. It suddenly came.
2023-01-23 09:06:38 +03:00 - QA-VOJS-02 - Info: Requesting process steps for queue "\QA-CLUSTER".
2023-01-23 09:06:38 +03:00 - QA-VOJS-02 - Serious: Last process step request failed with error: '"[810023] Error running statement: exec QBM_PJobQueueLoad N'\QA-CLUSTER', 90, -1, 1334229334, N'', N'8cf65e64-94f5-4693-bf51-df81d9324134'-->[810143] Database error 50000: detected in (SRV=QA-SQLSERVER\OIM, DB=OneIMDB) Procedure QBM_PJobQueueLoad, Line 43-->[810143] Database error 50000: Session ID for queue \QA-CLUSTER does not match. DB: 79c0a150-315d-43b9-9e93-445b10cc100d Query:8cf65e64-94f5-4693-bf51-df81d9324134."'!
2023-01-23 09:06:38 +03:00 - QA-VOJS-02 - Error occurred in DbRequestQueue.Process (thread: Database Job Requests):
[821002] Error requesting queue '\QA-CLUSTER' for database 'QA-SQLSERVER\OIM\OneIMDB'.
[810023] Error running statement: exec QBM_PJobQueueLoad N'\QA-CLUSTER', 90, -1, 1334229334, N'', N'8cf65e64-94f5-4693-bf51-df81d9324134'
[810143] Database error 50000: detected in (SRV=QA-SQLSERVER\OIM, DB=OneIMDB) Procedure QBM_PJobQueueLoad, Line 43
[810143] Database error 50000: Session ID for queue \QA-CLUSTER does not match. DB: 79c0a150-315d-43b9-9e93-445b10cc100d Query:8cf65e64-94f5-4693-bf51-df81d9324134.
at VI.JobService.DbProvider.DbRequestQueue.Process(ProviderRequest request)
at VI.JobService.MSSqlJobProvider._MsSqlRequestQueue._HandleGetJobs(IDbSession dbSession, GetJobsProviderRequest request)
---- Start of Inner Exception ----
at VI.JobService.MSSqlJobProvider._MsSqlRequestQueue._HandleGetJobs(IDbSession dbSession, GetJobsProviderRequest request)
at VI.Base.SyncActions.Do[T,T1,T2](T1 p1, T2 p2, Func`3 function)
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.<SqlExecuteAsync>d__37.MoveNext()
---- Start of Inner Exception ----
at VI.DB.DataAccess.ReadOnlyDbSession.<SqlExecuteAsync>d__37.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__49`1.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadOnlyDbSession.<>c__DisplayClass37_0.<<SqlExecuteAsync>b__0>d.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__43`1.MoveNext()
---- Start of Inner Exception ----
I also checked this article https://support.oneidentity.com/kb/4276524/error-in-job-server-log-database-error-50000-processing-is-disabled-this-queue-is-switched-off
Any suggestion? How to resolve this error?
