Hi

I have a very simple scenario.I am working on BizTalk 2004. I read
certain records from Source SQL Server 2000 using SQL Adapter. I have to
send these messages to destination SQL Server 2000 using SQL Adapter.
While inserting certain records there is a Unique Key Violation in SQL
server. In my orchestration I have a Exception Handling block. Following
are the problems I am facing here :

1. Exception thrown is of the type
Microsoft.Xlangs.Core.XlangSoapException. I am unable to find this
namespace anywhere in the BizTalk documentation neither in any of the
dlls supplied with BizTalk 2004.

2. If my first Exception Handling Block catches exception of the type
System.Exception then only I am able to catch this exception. If the
first exception handling block is handling exception of the type
Microsoft.Xlangs.BaseTypes.XLANGs.Exception, then also the exception is
not caught.

3. The exception object is of the type
Microsoft.Xlangs.Core.XlangSoapException. I am catching it as
System.Exception. The message contained in this object is "An exception
occured while processing this message. Refer to Detail section for more
information". Whereas Eventlog has all the details of the exception i.e.
there was Unique Key violation etc. How do I get this information out
of error object.

Thanks a lot in advance
Ashish Shukla

[ Post a follow-up to this message ]

Hi Ashish,

I have the same problem, but have hot had time to solve it yet.

Regarding the documentation, I could not find anything on how to handle
SQL errors from within an orchestration.

I looked around on here, and someone mentioned that you could access the
InnerException property of the XlangSoapException. I think the adapter will
take the SQL exception, and wrap it in the XlangSoapException. I had a quick
look at doing this, but did not spend too much time on it. I will look into 
it
next week sometime. (My email is in my "AboutMe" details if you want to
contact me).

Hope this is some help as a starter, good luck, please post back if you mana
ge
to solve it.

Regards,

Alan


"user@domain.invalid" wrote:

> Hi
>
> I have a very simple scenario.I am working on BizTalk 2004. I read
> certain records from Source SQL Server 2000 using SQL Adapter. I have to
> send these messages to destination SQL Server 2000 using SQL Adapter.
> While inserting certain records there is a Unique Key Violation in SQL
> server. In my orchestration I have a Exception Handling block. Following
> are the problems I am facing here :
>
> 1. Exception thrown is of the type
> Microsoft.Xlangs.Core.XlangSoapException. I am unable to find this
> namespace anywhere in the BizTalk documentation neither in any of the
> dlls supplied with BizTalk 2004.
>
> 2. If my first Exception Handling Block catches exception of the type
> System.Exception then only I am able to catch this exception. If the
> first exception handling block is handling exception of the type
> Microsoft.Xlangs.BaseTypes.XLANGs.Exception, then also the exception is
> not caught.
>
> 3. The exception object is of the type
> Microsoft.Xlangs.Core.XlangSoapException. I am catching it as
> System.Exception. The message contained in this object is "An exception
> occured while processing this message. Refer to Detail section for more
> information". Whereas Eventlog has all the details of the exception i.e.
>   there was Unique Key violation etc. How do I get this information out
> of error object.
>
> Thanks a lot in advance
> Ashish Shukla
>
>

[ Post a follow-up to this message ]

Hi Alan

Thanks for the prompt reply. The problem is that I do not know where
this class is. The exception thrown is of the type
"Microsoft.Xlangs.Core.XlangSoapException". The exceptions listed in the
documentation as well as the "Exception Types" in orchestration belong
to "Microsoft.Xlangs.BaseType" namespace. I could not find this
namespace anywhere. I looked at all the "dll" provided with biztalk but
got nothing. Untill and unless I get that
class(Microsoft.Xlangs.Core.XlangSoapException) I cannot catch the
exceptions of that kind. I hope this information is of some use.

Thanks again
Regards
Ashish Shukla

Alan Smith wrote:[vbcol=seagreen]
> Hi Ashish,
>
> I have the same problem, but have hot had time to solve it yet.
>
> Regarding the documentation, I could not find anything on how to handle
> SQL errors from within an orchestration.
>
> I looked around on here, and someone mentioned that you could access the
> InnerException property of the XlangSoapException. I think the adapter wil
l
> take the SQL exception, and wrap it in the XlangSoapException. I had a qui
ck
> look at doing this, but did not spend too much time on it. I will look int
o it
> next week sometime. (My email is in my "AboutMe" details if you want to
> contact me).
>
> Hope this is some help as a starter, good luck, please post back if you ma
nage
> to solve it.
>
> Regards,
>
> Alan
>
>
> "user@domain.invalid" wrote:
>
> 

[ Post a follow-up to this message ]

Microsoft.Xlangs.Core.XlangSoapException exception can not be used in
BizTalk orchestration.
It’s need to catch System.Web.Services.Protocols.SoapException.
Details member of SoapException contains detailed description of raised
exception.
This member has the following structure:
<ns0:NACK Type="NACK"
xmlns:ns0="http://schema.microsoft.com/BizTalk/2003/NACKMessage.xsd">
<NAckID>{EB2F6B1E-6B35-4D3B-96DE-B58E743BF050}</NAckID>
<ErrorCode>System.Net.WebException: The request failed with HTTP status
404: Not Found.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at WebService...TestTran()</ErrorCode>
<ErrorCategory>0</ErrorCategory>
<ErrorDescription>The request failed with HTTP status 404: Not
Found.</ErrorDescription>
</ns0:NACK>

[ Post a follow-up to this message ]

Microsoft.Xlangs.Core.XlangSoapException exception can not be used in
BizTalk orchestration.
It’s need to catch System.Web.Services.Protocols.SoapException.
Details member of SoapException contains detailed description of raised
exception.
This member has the following structure:
<ns0:NACK Type="NACK"
xmlns:ns0="http://schema.microsoft.com/BizTalk/2003/NACKMessage.xsd">
<NAckID>{EB2F6B1E-6B35-4D3B-96DE-B58E743BF050}</NAckID>
<ErrorCode>System.Net.WebException: The request failed with HTTP status
404: Not Found.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at WebService...TestTran()</ErrorCode>
<ErrorCategory>0</ErrorCategory>
<ErrorDescription>The request failed with HTTP status 404: Not
Found.</ErrorDescription>
</ns0:NACK>

[ Post a follow-up to this message ]