BizTalk Gurus
Forums » BizTalk Server » BizTalk 2004 » streaming not supported over multiple column result

streaming not supported over multiple column result

rated by 0 users
Not Answered This post has 0 verified answers | 1 Reply | 1 Follower

posted on Wed, Dec 2 2009 2:54 AM

Hi,

I am using SQL receive adapter to read new invoices information from SQL database using SQL stored procedure. My stored procedure is returning XML data using for XML AUTO in SQL 2000.

It is working fine till date but all of sudden I am getting streaming not supported over multiple column result error while calling stored procedure using SQL adapter.

Please note that we have neither changed SQL procedure not changed BizTalk orchestration.

Can anybody suggest me the solution for this problem?

Thanks in advance.

Regards,
Dhaval

 Quick Reply

All Replies

Top 10 Contributor
877 Posts
Reply
greg.forsythe replied on Wed, Dec 2 2009 4:29 AM

This error is generated from the SQL adapter, it means it is getting a dataset response instead of Xml.

Had this exact problem yesterday, someone had "temporarily" commented out the FOR XML in the stored procedure so they could view the result in tabular format. They forgot to remove the comment and reinstate the FOR XML.

 

 Quick Reply
Page 1 of 1 (2 items) | RSS