SQL Adapter – root element is missing

Home Page Forums BizTalk 2004 – BizTalk 2010 SQL Adapter – root element is missing

Viewing 1 reply thread
  • Author
    Posts
    • #15506

      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

    • #15505

      Does you custom disassembler set the BTS.MessageType property in the message context.
      The map will only be actioned if this property matches the source message type in the map.

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