none
Inserting XML format using message assignment into WCF-SQL Error RRS feed

  • Question

  • Hi,

    I got the following errors when I tried to pass an XML format into the WCF-SQL parameters.

    Please see below error message and the parameter I'm trying to pass to the thru WCF-SQL.

    Please advise. Thanks.

    The adapter failed to transmit message going to send port "InsertErrorLogDbSendPort" with URL "mssql://monwew201//FEBizTalkLogDb?". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: An unexpected text node was found before the start tag "OrderCreation" with namespace "http://OrderCreationHybrisToFE.OrderCreation". Please ensure that your input XML conforms to the schema for the operation.

    Server stack trace: 
       at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)

    Exception rethrown at [0]: 
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult result)".

    WCF-SQL Request parameters:

    <ns0:FEBizTalkLogError xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/Procedures/dbo">
      <ns0:source>OrderCreation</ns0:source>
      <ns0:description>Received unexpected message type '' does not match expected type 'http://tempuri.org/#OrderCreationResponse'.</ns0:description>
      <ns0:sourceContent>
    <ns0:OrderCreation xmlns:ns0="http://OrderCreationHybrisToFE.OrderCreation">
          <ns0:order>
            <ns0:orderId>00051402</ns0:orderId>
            <ns0:shipComplete>N</ns0:shipComplete>
            <poNumber>98989878</poNumber>
            <ns0:currency>$</ns0:currency>
            <ns0:exchangeRate>0.0</ns0:exchangeRate>
            <ns0:deliveryDate>20170316</ns0:deliveryDate>
            <ns0:orderDate>20170314</ns0:orderDate>
            <ns0:shippingTotal>252.6</ns0:shippingTotal>
            <ns0:totalTax>0.0</ns0:totalTax>
            <ns0:orderTotal>274.6</ns0:orderTotal>
            <ns0:subTotal>252.6</ns0:subTotal>
            <ns0:discountTotal>0.0</ns0:discountTotal>
          </ns0:order>
    </ns0:OrderCreation>

    </ns0:sourceContent>
    </ns0:FEBizTalkLogError>

    Monday, March 20, 2017 3:19 PM

Answers

  • You got error message: Received unexpected message type '', which means that you are using a passthrough receieve pipeline, you should use a xmlreceive pipeline.


    Monday, March 20, 2017 3:28 PM