While trying to retrieve data using the Oracle adapter we get the following
error.  We've followed the tutorial and looked at the samples but can't
figure out what we're missing.  Our environment is VS2005, BTS2006, and the
2006 Oracle adapter.

TIA,
Mike

Inner exception: An error occurred while processing the message, refer to
the details section for more information
Message ID: {CA3902E1-592A-48F4-9EF6-8582DDD7BA5E}
Instance ID: {34002AB9-5625-460A-AADF-9F0FA9A195CF}
Error Description: 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:
"OracleAUTODSPT2" URI:
"OracleDb://AUTODSPT_c07e2f93-00e5-44ac-b58e-fa52c0ee58e6" Reason: Root
element is missing.

[ Post a follow-up to this message ]

This was due to the Port being set to Pass Thru instead of XML.


"Mike Lewis" <mike.lewis@lgeenergy.no_spam.com> wrote in message
news:eGE4CImiGHA.412@TK2MSFTNGP05.phx.gbl...
> While trying to retrieve data using the Oracle adapter we get the
> following error.  We've followed the tutorial and looked at the samples
> but can't figure out what we're missing.  Our environment is VS2005,
> BTS2006, and the 2006 Oracle adapter.
>
> TIA,
> Mike
>
> Inner exception: An error occurred while processing the message, refer to
> the details section for more information
> Message ID: {CA3902E1-592A-48F4-9EF6-8582DDD7BA5E}
> Instance ID: {34002AB9-5625-460A-AADF-9F0FA9A195CF}
> Error Description: 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:
> "OracleAUTODSPT2" URI:
> "OracleDb://AUTODSPT_c07e2f93-00e5-44ac-b58e-fa52c0ee58e6" Reason: Root
> element is missing.
>

[ Post a follow-up to this message ]