DB2 Stored Procedure Response Error

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › DB2 Stored Procedure Response Error

Viewing 0 reply threads
  • Author
    Posts
    • July 8, 2009 at 11:57 AM #22817
      community-content

        Not that it will not be evident, but I am extremely new to BizTalk and the whole schema concept.  I am trying to call a DB2 Stored procedure and return the results.  I’m getting this error and I’m not sure what I have configured wrong.  And my schema below.  all my pipelines are XMLTransmit and my port Doc Target namespace is http://DB2ReceivePort1 and response root element name is S00001SP_Response.

         

        Thanks in advance

         

         

        Error details: There was a failure executing the response(receive) pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “XML disassembler” Send Port: “TOPS_SPROC_Port”  Reason: Finding the document specification by message type “http://DB2ReceivePort1#Success” failed. Verify the schema deployed properly.

        MessageId: {2A82F7A4-D948-4939-A815-777116368727}

        InstanceID: {4F1F061D-0E3E-4FA8-A49A-10A01B657F69}

        <?xml version=”1.0″ encoding=”utf-16″ ?>

        – <xs:schema xmlns:tns=”http://DB2ReceivePort1“ xmlns:b=”http://schemas.microsoft.com/BizTalk/2003“ targetNamespace=”http://DB2ReceivePort1“ xmlns:xs=”http://www.w3.org/2001/XMLSchema“>
        – <xs:annotation>
        – <xs:appinfo>
          <schemaInfo is_envelope=”yes“ xmlns=”http://schemas.microsoft.com/BizTalk/2003“ />
          </xs:appinfo>
          </xs:annotation>
        – <xs:element name=”TOPSDataService“>
        – <xs:annotation>
        – <xs:appinfo>
          <b:recordInfo body_xpath=”/*[local-name()=’TOPSDataService’ and namespace-uri()=’http://DB2ReceivePort1′%5D“ xmlns:b=”http://schemas.microsoft.com/BizTalk/2003“ />
          </xs:appinfo>
          </xs:annotation>
        – <xs:complexType>
        – <xs:sequence>
        – <xs:element xmlns:updategram=”urn:schemas-microsoft-com:xml-updategram“ updategram:Prefix=”updg“ minOccurs=”1“ maxOccurs=”unbounded“ name=”sync“>
        – <xs:complexType>
        – <xs:sequence>
        – <xs:element minOccurs=”1“ maxOccurs=”unbounded“ name=”StoredProcedure“>
        – <xs:complexType>
        – <xs:sequence>
        – <xs:element minOccurs=”1“ maxOccurs=”1“ name=”S00001SP“>
        – <xs:complexType>
          <xs:attribute name=”P_POLICY_NUMBER“ type=”xs:string“ />
          </xs:complexType>
          </xs:element>
          </xs:sequence>
          </xs:complexType>
          </xs:element>
          </xs:sequence>
          </xs:complexType>
          </xs:element>
          </xs:sequence>
          </xs:complexType>
          </xs:element>
        – <xs:element name=”S00001SP_Response“>
        – <xs:annotation>
        – <xs:appinfo>
          <b:recordInfo body_xpath=”/*[local-name()=’S00001SP_Response’ and namespace-uri()=’http://DB2ReceivePort1′%5D“ />
          </xs:appinfo>
          </xs:annotation>
        – <xs:complexType>
        – <xs:sequence>
        – <xs:element name=”Success“>
        – <xs:complexType>
        – <xs:sequence>
          <xs:element minOccurs=”0“ maxOccurs=”1“ name=”RowsAffected“ type=”xs:int“ />
          <xs:element minOccurs=”0“ name=”ResultSets“ type=”xs:anyType“ />
          </xs:sequence>
          </xs:complexType>
          </xs:element>
          </xs:sequence>
          </xs:complexType>
          </xs:element>
          </xs:schema>
    • Author
      Posts
    Viewing 0 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.