Re: 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’." › Re: The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="Could not find stored procedure ‘AnalyzerResult’."

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?