Unknown exception from SQL Adapter – exception handling?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Unknown exception from SQL Adapter – exception handling?

Viewing 1 reply thread
  • Author
    Posts
    • December 13, 2006 at 4:10 AM #16872
      community-content

        Hi, i'm pretty new to Biztalk, and am attempting to output an XML file to a SQL database.

        Having
        followed a Microsoft walkthrough on how to do this, i've taken all the
        necessary steps (set up and configured the SQL send port, generated the
        SQLXML schema using the wizard, mapped my message to this new schema,
        set the namespaces in both the wizard and on the send port etc), but am
        encountering an unknown error.

        The xml file does not get output
        to the SQL table, and when i go into HAT to see what the error was, the
        only information it gives me is

        Service/Name: Microsoft.BizTalk.DefaultPipelines.XMLTransmit
        ServiceInstance/ExitCode: -2146232832
        ServiceInstance/ErrorInfo: (just two box-shaped characters displayed here)

        Evidently this is some kind of unknown exception, but without seeing some kind of error message, i have absolutely zero chance of fixing it.

        Is there some way to actually retrieve an error message for this exception?

        Any help would be greatly appreciated

        Cheers 

      • December 13, 2006 at 8:44 AM #16878
        community-content

          I am not exactly sure how you are doing things, but my guess is that the message is malformed.  Likely namespacing is the problem.

          First off if you are using the stored procedure technique, that returns a result set, make sure the xmldata option is commented out.

          Then generate an instance for the generated schema and compare that to what you are sending in.

           

          • December 13, 2006 at 9:24 AM #16882
            community-content

              I'm actually using UpdateGrams to insert straight into the table in question, but i will double check all the relevant namespaces i can find.

              I'm away for a week from today, so i'll post back then.

              Cheers for the help 

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