RE: TrackedMessages_Copy_BizTalkMsgBoxDb error.

I did compare the code between environments and its exactly the same. I did
run it through query analyzer and know its line 79 where it is failiing. I
ended up creating a support case with Microsoft, hopefully we will have a
solution pretty soon.

Thanks!
Krishna V

"Thiago" wrote:


Compare the code of stored procedure bts_CopyTrackedMessagesToDTA in the
message box database on both environments. You can also run the code inside
the stored procedure manually in Query Analyzer to see exactly where it's
failing.

Thiago Almeida
http://connectedthoughts.wordpress.com

"Krishna V" wrote:

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




.

Relevant Pages

  • Re: Exception when uisng Intersect method
    ... C# provides syntax for exception handling through try..catch..finally blocks. ... as long as your range objects aren't NULL/Nothing, ... You can compare Addressresults ... For workbooks, since there's a possibility multiple Excel ...
    (microsoft.public.excel.programming)
  • Re: ExecuteNonQuery stops program
    ... in Query Analyzer - or run a trace and see what's happening w/ it. ... > exception not coming to the end of the method. ... > SqlConnection sqlConnection3 = new SqlConnection; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Strange exception
    ... exception, although it is really not clear what causes the exception ... The second time through, ... going on is that TreeSet keeps its entries sorted, ... Comparable, so it can compare them, but "array of byte" doesn't ...
    (comp.lang.java.programmer)
  • Re: Exception: The SqlTransaction has completed; it is no longer usabl
    ... > I hv encountered this exception 'The SqlTransaction has completed; ... returning around 9000 rows in a DataSet and back to the app. ... > When that exception is thrown, I tried running the same stored procedure ... > I was thinking if Query Analyzer can return data very quickly... ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Enumeration idioms: Values from different enumerations
    ... That is, trying to compare ... > exception) *because* the whole point of enumerations is to avoid ... if a specific enum value is in the list, and the obvious way to check ... exception - it takes a relatively convoluted bit of code to make this ...
    (comp.lang.python)