Describe the bug
After a queue item is processed, the conversation endpoint status remains in CONVERSING state and the record remains in sys.conversation_endpoints in perpetuity.
To Reproduce
Execute any workflow using Sql Queue Provider.
Expected behavior
After the queue item is processed, the conversation endpoint status is changed to CLOSED and is removed from sys.conversation_endpoints after lifetime expiration.
Additional context
QueueWork.sql and DequeueWork.sql are not ending the conversation
Describe the bug After a queue item is processed, the conversation endpoint status remains in CONVERSING state and the record remains in sys.conversation_endpoints in perpetuity.
To Reproduce Execute any workflow using Sql Queue Provider.
Expected behavior After the queue item is processed, the conversation endpoint status is changed to CLOSED and is removed from sys.conversation_endpoints after lifetime expiration.
Additional context QueueWork.sql and DequeueWork.sql are not ending the conversation