DB2 stored procedure call error SQLSTATE:42884, SQLCODE: -440

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › DB2 stored procedure call error SQLSTATE:42884, SQLCODE: -440

Viewing 1 reply thread
  • Author
    Posts
    • February 19, 2010 at 7:39 AM #24248
      community-content

        In my orchestration, I am calling an AS400 stored procedure.  I am using a DB2 adapter to call the stored procedure.  I keep getting the following error.  “Error details: Routing in O SQLSTATE:42884, SQLCODE:-440”.   Has anyone experienced this problem?  I need help.  The port just suspends.

         

         

      • February 19, 2010 at 12:44 PM #24255
        community-content

          Hi,

           

             I googled this error and found out that this has something to do with the way you call your DB2 stored procedure. Have a look at the following link for an explanation of this error message (do a search on 42884 in the body of this document):

           

          http://www.cs.toronto.edu/db/courses/343/Summer2003_L5201/DB2/msgs_2.pdf

           

             Btw, this is not an error related to BizTalk or its DB2 adapter…

           

             Hope this helps…

           

             Daniel.

           

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