The conversation handle DEAC4396-52FF-ED11-9320-00505695297E is not found. [SQLSTATE 42000] (Error 8426)

Question

I have a service job which is on sql server 2019 and runs daily - it mainly executs fine, but fails every so oftern with the following error and I have looked into sql server error logs, event logs etc. and there dosn't seem to be a specific information to why it fails, would you please let me know what the error means?

Thank you in advance

The conversation handle "DEAC4396-52FF-ED11-9320-00505695297E" is not found. [SQLSTATE 42000] (Error 8426) Service Broker conversations cleaned up 95 [SQLSTATE 01000] (Message 0). The step failed.

Answer 1

The error means what it says. The conversation handle is missing when it should not be. When you run BEGIN DIALOG you get a conversation handle, and then you use this in the SEND command. The other party will typically also reply using the conversation handle.

This error suggests that some party runs END CONVERSATION on its own initiative, while the other party still has the handle and wants to use it. It could also be an outsider that runs END CONVERSATION, or even worse END CONVERSATION WITH CLEANUP.