Guys,
I am going insane!
Here is the problem:
1 – I read a binary file from an FTP directory using the FTP adapter, then
2 – I use a custom pipeline with a custom IDisassembler component (Disassemble, GetNext methods overriden)
to convert the binary message (batch of binary msgs) into several Xml BizTalk messages (IBaseMessage), during this stage
I promote the properties required by the messeging engine to recognize the messages
NOTE: I am able to see the messages are being passed successfully to the orchestration
3 – I use a map to convert the passed message from the pipeline into the orchestration
to the schema of an SP request (Generated by BizTalk to use the SQL Adapter)
4 – I send the result of the map, that is SQLMsg.procedureRequest to the send adapter (SQL) in order
to invoke an SP on the local SQL server 2005 instance
5 – I get the following error:
There was a failure executing the send pipeline:
\”Microsoft.BizTalk.DefaultPipelines.XMLTransmit, Microsoft.BizTalk.DefaultPipelines,
Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\” Source:
\”XML assembler\” Send Port: \”SendPort2\” URI: \”SQL://ES-SYS371/BatelcoPOC/\” Reason:
Root element is missing.
NO WAY, the map is supposed to construct the message, right?
This is really weird
ANy Help plz