BizTalk 2009 Message error - The following procedure call failed

Question

Very frequently 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.".

score 0 · Answer 1 · answered Sep 22 '09 at 18:18

0

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?)

answered Sep 22 '09 at 18:18

tomasr

13,683
3
38
30

Nothing as such happened; Its on a VM. Even the SQL server is installed with all the deafult / biztalk dependent settings. – Muralidhar Sep 22 '09 at 19:42
We are getting the same symptoms. Pity that there is no solution to this. – Lee Simpson Feb 05 '12 at 22:29
Seeing the same error with BizTalk 2013r2 on Sql Server 2012r2 – Rob Bowman Jan 09 '19 at 13:23

score 0 · Answer 2 · answered Jan 09 '19 at 13:34

0

I was able to work-around this by disabling tracking on the send port that was sending my message

answered Jan 09 '19 at 13:34

Rob Bowman

7,632
22
93
200

BizTalk 2009 Message error - The following procedure call failed

2 Answers2