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

Error: Running History Database Schedule

So in the past the HistoryDB was working and it just stopped processing data a few months ago. The error comes from the HistoryDB server once I execute the schedule "Import Process Information Directly". The jobQ task seems to run fine but the logs reflect the error.

 

Has anyone had a similar error?

 

2018-02-13 16:04:00 -06:00 - Serious: Last process step request failed with error: '[810023] Error during execution of statement: exec QBM_PJobQueueLoad N'\HISTORYDBSVR', 90, -1, 2074973947, N'', N'161b85b0-96bd-4948-84e0-e073120cb191'-->[810143] Database error 50000: detected in (SRV=HISTORYDBSVR\HDBSQL, DB=D1IM) Procedure QBM_PJobQueueLoad, Line 41-->[810143] Database error 50000: Session ID for queue \HISTORYDBSVR does not agree. DB: d62afd6e-e883-4394-b3ec-0d1bc6bf69c2 Query:161b85b0-96bd-4948-84e0-e073120cb191.'!
2018-02-13 16:04:00 -06:00 - Exception occured in DbRequestQueue.Process (thread: Database Job Requests):
[821002] Error requesting queue '\HISTORYDBSVR' for database 'HISTORYDBSVR\HDBSQL\D1IM'.
    [810023] Error during execution of statement: exec QBM_PJobQueueLoad N'\HISTORYDBSVR', 90, -1, 2074973947, N'', N'161b85b0-96bd-4948-84e0-e073120cb191'
    [810143] Database error 50000: detected in (SRV=HISTORYDBSVR\HDBSQL, DB=D1IM) Procedure QBM_PJobQueueLoad, Line 41
    [810143] Database error 50000: Session ID for queue \HISTORYDBSVR does not agree. DB: d62afd6e-e883-4394-b3ec-0d1bc6bf69c2 Query:161b85b0-96bd-4948-84e0-e073120cb191.
           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__42`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 ----