Hello all,
We are facing an issue with TrackedMessages_Copy_BizTalkMsgBoxDb: this job
on our production server is throwing an exception as follows..
"Executed as user: xyz. Line 2: Incorrect syntax near 'mp'. [SQLSTATE
42000]
(Error 170) Incorrect syntax near the keyword 'ORDER'. [SQLSTATE 42000]
(Error 156) An error occurred while inserting data in the Tracking_Parts1
table [SQLSTATE 42000] (Error 50000) Warning: The join order has been
enforced
because a local join hint is used. [SQLSTATE 01000] (Error 8625). The
step
failed."
We have another set of production servers where this job is not throwing
this exception. Did do some research and could not find anything specific
to
the above exception.
BizTalk having issues environment : Windows 2k3 SP1, Biztalk 2006
Enterprise
edition. Messagebox is SQL 2000.
BizTalk NOT having issues environment : Windows 2k3 SP1, Biztalk 2006
Enterprise edition. Messagebox is SQL 2005.
Has anyone seen this kind of exception before? Are there any solutions to
this one?
Any help would be greatly appreciated!
Thanks in Advance,
Krishna
