Exception handling in biztalk server for request-response port for sql adapter

Home Page Forums BizTalk 2004 – BizTalk 2010 Exception handling in biztalk server for request-response port for sql adapter

Viewing 1 reply thread
  • Author
    Posts
    • #16517

      hi,

       

      i checked the blog suggested at

      http://dallas.sark.com/SarkBlog/mholdorf/archive/2004/10/22/442.aspx

      but it also does not suggest how to get exact error message. 

      When we use a request-response ie send type of port for sql adapter and try to handle a exception like

      database errors like primary key,null values etc

      newtwork problems like database down,msdtc service off etc

      the exception is catched by soap exception but we do not get any correct exception message.

      it just says exception occurred.

      we need exact reason for same.

      do we need to catch diff exceptions like sqlexception,socketexception etc for same?

      this a old problem and cant get any solution for same. 

       

       

    • #16531

      You probably have to cast the exception into a SOAP exception.  See my sample on NACKs (http://www.biztalkgurus.com/Samples/Delivery-Notification-NAck-Orchestration.html) under BizTalk 2004.

       

      An alternative I use sometimes is I’ll just make the call inside a .net component called from an Orchestration.  That way I have better control over the errors – but I lose all the benefits of the adapter framework.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.