Biztalk error: Exception occurred when persisting state to the database

Question

I am attempting to insert XML message into Biztalk message box database and I am getting the error

Exception occurred when persisting state to the database.

I have an orchestration which needs to read this message from the message box. I have applied appropriate filter in receive port of the orchestration. Also the filter criteria is matched with the xml which I am trying to insert.

Can anybody throw some light on this problem?

Answer 1

I have resolved the problem. The orchestration which reads the inserted message from message box doesn't have the direct port and so when I try to insert a message in message box it doesn't find the subscriber of that message.

I have made the orchestration port as direct port and problem got resolved.

Answer 2

Check if you have duplicate subscriptions in your Message Box. This is one of those errors that can happen for a number of reasons, but this is the first thing I will investigate when I encounter it.

Here's a blog post I wrote about this situation a while ago.

To check your active subscriptions, use BizTalk Administration Console, and on the 'New Query' tab, change the 'Search for' drop-down to 'Subscriptions'