how to catch error from sql adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › how to catch error from sql adapter

Viewing 1 reply thread
  • Author
    Posts
    • January 24, 2006 at 12:51 PM #12715
      community-content

        we are using sql adapter of type receive to take data from one db and a sql adapter of type send to insert into other db using stored procedures

        if a parameter to insert into other db comes null at runtime there is error executing other 2nd procedure

        the exception is raised by sql adapter and able to see in event viewer

        but i want to catch exception in orchestration ,i used a scope with a exception handler for system.exception but exception from sql adapter is not catched i want to send a mail if exception occurs

      • January 26, 2006 at 8:07 PM #12716
        community-content

          Hi Mr. Neal Walters,

          I’ve tried catching a SOAPException, but nothing occurs.
          Maybe I’m missing something, In the catch block, I have an expression shape with the following code:

          [code:1:895a6fe256]System.Diagnostics.EventLog.WriteEntry(\"SQL\", \"Se produjo un error en SQL Server\", System.Diagnostics.EventLogEntryType.Error);[/code:1:895a6fe256]

          Then in my sp, I insert a duplicate key so an error occurs, but my orchestration doesn’t log any error in the event viewer.

          Can you help me, please? 😀

          Saludos. Mauricio.

          Buenos Aires – Argentina

          • February 17, 2006 at 10:36 AM #12717
            community-content

              Why is it I already catch soapexception but still dont get any exception, but Biztalk is logging it in event viewer?

              any idea or sample, to handle exception thrown by sql adapter.

              Cheers,

              Alex Tantiangco

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