• State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 93 subscribers
  • Views 4086 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

HA One IM version 8.0

vijay.anand
over 6 years ago

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

Parents
  • +1 over 6 years ago
    Vijay,

    From your screenshots, I could tell that your configuration is incorrect. The reason is that your configuration for the job servers should be in terms of the cluster virtual IP Address/cluster name.

    Your job server configurations should be similar to below:
    1. Server = ADIDMCLS
    2. Queue = ADIDMCLS

    You should not have any configurations that shows your cluster nodes.

    Also, the last thing that you need is to set the "HTTP server IP address" value in the JobServer.cfg file. This is necessary because your job server node is dual homed and you need to bind to the correct IP Address. The IP Address you put in there should be the clustered IP Address.
Reply
  • +1 over 6 years ago
    Vijay,

    From your screenshots, I could tell that your configuration is incorrect. The reason is that your configuration for the job servers should be in terms of the cluster virtual IP Address/cluster name.

    Your job server configurations should be similar to below:
    1. Server = ADIDMCLS
    2. Queue = ADIDMCLS

    You should not have any configurations that shows your cluster nodes.

    Also, the last thing that you need is to set the "HTTP server IP address" value in the JobServer.cfg file. This is necessary because your job server node is dual homed and you need to bind to the correct IP Address. The IP Address you put in there should be the clustered IP Address.
Children
No Data