The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="Could not find stored procedure ‘AnalyzerResult’."

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="Could not find stored procedure ‘AnalyzerResult’."

Viewing 1 reply thread
  • Author
    Posts
    • April 24, 2008 at 4:52 AM #19455
      community-content

        Hi,

        I am using SQL Adapter for inserting records into the database. I am using simply passthrureceive and passthrutransmit pipelines at receiving and sending end. the xml message is parsed against the schema at recieving end and trnasformation rules are neeeded to apply throough .btm file. I am using different stored procedure to push the data into database. But i don’t know why this error message is coming like :

        The adapter “SQL” raised an error message. Details “HRESULT=”0x80040e14″ Description=”Could not find stored procedure ‘AnalyzerResult’.””.

        this is noly the element in my schema not prodedure. can anyone help me out?

        Regards,

        Vivek.

      • April 29, 2008 at 6:05 AM #19484
        community-content

          When the SQL adapter receives a message, it looks at the first child node of the root node.

          If this is an updategram message (updg: sync xmlns:updg=”urn:schemas-microsoft-com:xml-updategram” >
          Then the adapter uses SQLXML to apply the updategram.

          Otherwise it will use this nodes name as a stored procedure name, and any child nodes as parameters to the stored procedure.

          How did you create the schema for the message you are sending to the SQL adapter?

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