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 with Stored Procedure QBM_PJobUpdateState

We are currently seeing a repeated error with the stored procedure QBM_PJobUpdateState in our job queue logs. The error message says:

Exception occurred in DbRequestQueue.Proces (thread: Database Job Results):

[810023] Error during execution of statement: exec QBM_PJobUpdateState @uid, @state, @success

[810143] Database error 50000: detected in (SRV=EALWNT80, DB=D1IMDEV) Procedure QBM_PJobUpdateState, Line 36

[810143] Database error 50000; The process step to update is missing. Tree: not exists missing process step: not exists.

It's unclear what is triggering the stored procedure to run. However, we think it may be related to some jobs that were deleted from the job queue last week. We have also tried restarting the job server in order to clear the cache, but the error is still appearing.

Any thoughts on the cause of this error and the best way to stop it would be greatly appreciated.

Thanks,
James