Hi Experts,
My sql db is already clustered. I have installed the One IM schemas on virtual cluster instance.
While installing the DB Job service I have pointed the computer name on 2 different machine with the same server functions(SQL processing) and machine role.Both the service runs.
But I dont see the result, if one db job service fails it's picking from the other machine. Am I doing anything wrong. When the both the service are up and below is log for server1 and server2 looks good.
2018-03-19 16:43:25 +04:00 - DBSRV01 - Serious: Last process step request failed with error: '[810023]
Error during execution of statement: exec QBM_PJobQueueLoad N'\ADIDMCLSVSR01', 60, -1, 1354828520, N'',
N'5c7a596a-59cc-408a-b650-8a20fef8210f'-->[810143] Database error 50000: detected in (SRV=ADIDMCLSVSR01\ADIDMPSQL01, DB=OneIM)
Procedure QBM_PJobQueueLoad, Line 44-->[810143] Database error 50000: Session ID for queue \ADIDMCLSVSR01 does not agree.
DB: 9722b05c-b86c-4d64-b92e-8278e3a549b3 Query:5c7a596a-59cc-408a-b650-8a20fef8210f.'!
2018-03-19 16:43:25 +04:00 - DBSRV01 - Error occurred in DbRequestQueue.Process (thread: Database Job Requests):
[821002] Error requesting queue '\ADIDMCLSVSR01' for database 'ADIDMCLSVSR01\ADIDMPSQL01\OneIM'.
[810023] Error during execution of statement: exec QBM_PJobQueueLoad N'\ADIDMCLSVSR01', 60, -1, 1354828520, N'', N'5c7a596a-59cc-408a-b650-8a20fef8210f'
[810143] Database error 50000: detected in (SRV=ADIDMCLSVSR01\ADIDMPSQL01, DB=OneIM) Procedure QBM_PJobQueueLoad, Line 44
[810143] Database error 50000: Session ID for queue \ADIDMCLSVSR01 does not agree. DB: 9722b05c-b86c-4d64-b92e-8278e3a549b3 Query:5c7a596a-59cc-408a-b650-8a20fef8210f.
at VI.JobService.DbProvider.DbRequestQueue.Process(DbRequest request)
at VI.JobService.DbProvider.DbRequestGetJobs.Process(IDbSession dbSession, RequestDispatcher dispatcher)
---- Start of Inner Exception ----
at VI.JobService.DbProvider.DbRequestGetJobs.Process(IDbSession dbSession, RequestDispatcher dispatcher)
at VI.Base.SyncActions.Do[T](Func`1 function)
at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
---- Start of Inner Exception ----
at VI.DB.DataAccess.ReadOnlyDbSession.<SqlExecuteAsync>d__36.MoveNext()
---- Start of Inner Exception ----
at VI.DB.DataAccess.ReadOnlyDbSession.<SqlExecuteAsync>d__36.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__46`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.<>c__DisplayClass36_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__40`1.MoveNext()
---- Start of Inner Exception ----
Thanks,
Vijay
