none
WCF LOB Adapter - Issue with Select operation RRS feed

  • Question

  • Hi,

    By using WCF lob adapter, I am trying to do select operation.

    Below is the xml generated for select req: 

    <ns0:Select xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/Acc_">
      <ns0:Columns>*</ns0:Columns>
      <ns0:Query>WHERE ID = 18 </ns0:Query>
    </ns0:Select>

    I am getting the below error. 

    The adapter failed to transmit message going to send port "WcfSendPort_SqlAdapterBinding_TableOp_dbo_Acc_Custom" with URL "mssql://sql-non.net//processing?". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.NullReferenceException: Object reference not set to an instance of an object.

    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)".

    Please suggest on resolving the error.



    Thanks & Regards, Sridhar

    Friday, January 19, 2018 2:19 PM

All replies