[BTS] The join order has been enforced because a local join hint is used.;D Uplicate key was ignored. ".

In a customer's BizTalk Server R2 environment, the following error is reported, and there is no reason to find out.

Log name:application
Source:biztalk Server
date:3/3/2015 7:59:12 AM
Event id:6912
Task category:biztalk Server
Level:error
Keywords:classic
user:n/a
Computer:biztalk_prd_server
Description:
the following stored procedure call failed: ' {call [dbo].[ BTS_UPDATEMSGBOX_XXXXXXXXX] (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} ". 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.;D Uplicate key was ignored. ".
Event Xml:
<event xmlns= "Http://schemas.microsoft.com/win/2004/08/events/event" >
<System>
<provider name= "BizTalk Server"/>
<eventid qualifiers= "49344" >6912</EventID>
<Level>2</Level>
<Task>1</Task>
<Keywords>0x80000000000000</Keywords>
<timecreated systemtime= "2015-03-02t23:59:12.000000000z"/>
<EventRecordID>79877</EventRecordID>
<Channel>Application</Channel>
<Computer>BizTalk_PRD_Server</Computer>
<security/>
</System>
<EventData>
<Data> {call [dbo].[ BTS_UPDATEMSGBOX_XXXXXXXXXXXXX] (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} </Data>
<data>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.;D Uplicate Key was ignored.</data>
</EventData>
</Event>

Reference

https://social.msdn.microsoft.com/Forums/en-US/2b07de27-7e70-462d-af66-a6d535cdc886/ Biztalk-2009-sql-msgbox-error?forum=biztalkgeneral

1.Sometimes we get this error when the SQL Server is too busy to execute this stored proc, so better keep a eye on sq L Server Performance.

2.There could be temporory network glitch, is getting this error regularly?

3.I increased the VM memory to 2Gb and reduced the amount of BizTalk tracking -if I set tracking of Properti ES & Message bodies on receive, the problem seemed to occur more often.

4.the problem doesn ' t Seem to occur if the tracking message bodies on receive Port was not been Set.

5. It was fixed by unchecking tracking.

[BTS] The join order has been enforced because a local join hint is used.;D Uplicate key was ignored. ".