Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk Error while running a XML file for inseeting the records into the database
- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
January 25, 2015 at 4:08 AM #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”>
<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
-
March 13, 2015 at 6:17 AM #26501
is the above resolved ?
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.