I have an orchestration that has a scope shape. Inside the shape I have my
SQL send/receive ports. I have an exception handler for that scope...I've
tried using a general exception handler and a SOAP exception handler, both
with the same (lack of) results. Inside the exception hanlder I have a
terminate shape with a custom error. Whenever the SQL stored proc being
called by the send port throws an error processing is _not_ passed to my
error handler. Instead biztalk suspends the message. My orchestration is set
to a long running transaction, as is my scope shape. I've set the
synchronized property of the scope shape to true. I've set delivery
notification of the port to true. Not sure what else to try. Here are the
three messages that get generated in the event log whenever the sproc throws
an error:

***********
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e07"
Description="The statement has been terminated."
HRESULT="0x80040e07" Description="The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value."
".
***********

The "SQL" adapter is suspending an outbound message going to destination
URL:"SQL://ARRAKIS/Test/". Details:"HRESULT="0x80040e07" Description="The
statement has been terminated."
HRESULT="0x80040e07" Description="The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value."
".
***********

The Messaging Engine has suspended "1" message(s) from adapter "SQL" due to
failures in message processing. Please refer to Health and Activity Tracking
tool for more detailed information on this failure.



I have SP1 for biztalk installed...

[ Post a follow-up to this message ]

Have a look at
http://dallas.sark.com/SarkBlog/mho...10/22/442.aspx,
maybe this helps you

[ Post a follow-up to this message ]

Thanks for the info, but I already reviewed that blog and tried to recreate
the results without success. It almost seems as if SP1 isn't installed. The
only thing I can think to try is to uninstall then reinstall SP1.

In the meantime, does anyone have a sample solution with a catch on an sql
send port that they know works? At least using a sample solution I'll be abl
e
to tell if there is something funky with my biztalk install.


"Dick Dijkstra" wrote:

> Have a look at
> http://dallas.sark.com/SarkBlog/mho...10/22/442.aspx,
> maybe this helps you
>
>

[ Post a follow-up to this message ]