Biztalk Error while running a XML file for inseeting the records into the database

Home Page Forums BizTalk 2004 – BizTalk 2010 Biztalk Error while running a XML file for inseeting the records into the database

Viewing 1 reply thread
  • Author
    Posts
    • #26489

      Excellent job on done by all on this forum. Actually, I am new to BizTalk and was trying to set-up a small project to insert records through XML file into the database. I have done all the configuration by learning through bliogs. But when I try to run the project through Console, I have a following error/warningmessage.

      =======================================ERROR=========================================================The adapter failed to transmit message going to send port “InsrtSQLRec” with URL “mssql://.//Test_Aj_EDI?”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Microsoft.ServiceModel.Channels.Common.MetadataException: Object [dbo].[ID] of type StoredProcedure does not exist

      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)=======================================ERROR=========================================================
      Can someone have a look on the same. The XML of the following is :

      <?xml version=”1.0″?><ns0:ProductExt xmlns:ns0=”http://KillerProject.ProductExt”&gt;

      <ID>2</ID>

      <Name>Test</Name>

      <Description>TestDesc</Description>

      <Price>0</Price>

      <Quantity>1</Quantity>

      </ns0:ProductExt>

      Please help me to get through this. Also, can someone refer me step by step configuration setup to validate my project.
      Thanks,

      Ajit Singh

    • #26501

      is the above resolved ?

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