- This topic has 2 replies, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
Hi , we are getting an error message when i process edi data to sql server database using wcf-sql adaptor . :”Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The start element with name “N” and namespace “http://schemas.microsoft.com/Sql/2008/05/Procedures/dbo” was unexpected. Please ensure that your input XML conforms to the schema for the operation let me know how to fix the issue
-
Hi,
First thing you can do to find reason is to validate the message which you are sending to SQL against the schema. It normally happens when you try to send message with different root node.
Also it would be helpful to test the map (probably mapping is not creating correct message)
-
i am also getting same error while transforming the data from xml to sql through wcf-adapoter. i validated schema and test the mapping .. those are getting replay what i expected.
but i am getting error on wcf-adopter.: pasted bellow
The adapter failed to transmit message going to send port "WcfSendPort_SqlAdapterBinding_Procedures_DM_Custom" with URL "mssql://sdasyapu01//CVM_Testnet_DryRun20140122_CSD?". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The start element with name "XSHT1841" and namespace "" was unexpected. Please ensure that your input XML conforms to the schema for the operation
Any help on this:
i used mapping in inbound in wcf_sql adopter and i am not using any orchestration
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.