BizTalk 2009 Message error - The following procedure call failed...

Question

Very freequently the following error is getting logged into Application event logs on my BizTalk 2009 VM. But this error is inconsistent. Any clues?

The following stored procedure call failed: " { call [dbo].bts_UpdateMsgbox_BizTalkServerApplication}". SQL Server returned error string: "Warning: The join order has been enforced because a local join hint is used.;Warning: The join order has been enforced because a local join hint is used.;Duplicate key was ignored.".

Answer 1

I haven't seen that error myself, but it sounds like someone messed with the BizTalkMsgBox DB. Have your DBAs by any chance changed any of the sql server settings, or maybe messed with the BizTalkMsgBox indices? (like rebuild them?)