|
Home > Archive > BizTalk Server Orchestration > November 2004 > Streaming not supported
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Streaming not supported
|
|
| Woltore 2004-11-18, 7:46 am |
| Hi,
I have solution that reads a header date from SQL database table and later
on orchestration it tries to read lines from another table based on header
data.
But I'm getting error:
<?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL
Server" Description="Streaming not supported over multiple column
result"?>
What does that error mean?
Only info I found was that I should remove "FOR XML" from my schema, but
that didn't help?
What I'm doing wrong?
Thanks!
Woltore
| |
| Matt Meleski 2004-11-18, 7:46 am |
| The select statement should look something like this :
Select * from myTable
For XML AUTO
If you are using a stored procedure, make sure that
you comment out print statements or other Select Statements
in the stored procedure.
Matt.
"Woltore" wrote:
> Hi,
>
> I have solution that reads a header date from SQL database table and later
> on orchestration it tries to read lines from another table based on header
> data.
>
> But I'm getting error:
> <?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL
> Server" Description="Streaming not supported over multiple column
> result"?>
>
> What does that error mean?
>
> Only info I found was that I should remove "FOR XML" from my schema, but
> that didn't help?
>
> What I'm doing wrong?
>
> Thanks!
> Woltore
>
>
>
>
| |
| Woltore 2004-11-19, 7:46 am |
| Hi,
I didn't quite understand what you mean by "comment out select
statements"?
and yes I'm using stored procedure
my procedure is like:
CREATE PROCEDURE .symbian
@ID char(8)
AS
SELECT *
FROM PARTS
WHERE LABTRANSID = @ID
FOR XML AUTO, XMLDATA
GO
Should I change that somehow?
Woltore
| |
| Matt Meleski 2004-11-19, 7:46 am |
| When you get your system up and running the select statement should look like
this:
SELECT *
FROM PARTS
WHERE LABTRANSID = @ID
FOR XML AUTO
the XMLDATA statment is only needed when first creating the schema,
otherwise comment it out.
What I meant by commenting out other select statements , is :
Lets say you are doing other operations in your stored procedure, and
before your select statement :
SELECT *
FROM PARTS
WHERE LABTRANSID = @ID
FOR XML AUTO
you have another select statement for instance :
SELECT * FROM Products.
, then comment out that one -> SELECT * FROM Products..
as you are returning extra information that Biztalk cannot handle.
The best thing to do is go into Sql Quert Analyzer and run your stored
procedure
like : exec symbian 'someid'
All you you should see is something like :
XML_F52E2B61-18A1-11d1-B105-00805F49916B
--------------------------------------------------------------
<Some XML here>
2 rows affected
"Woltore" wrote:
> Hi,
>
> I didn't quite understand what you mean by "comment out select
> statements"?
>
> and yes I'm using stored procedure
> my procedure is like:
>
> CREATE PROCEDURE .symbian
> @ID char(8)
> AS
> SELECT *
> FROM PARTS
> WHERE LABTRANSID = @ID
> FOR XML AUTO, XMLDATA
> GO
>
> Should I change that somehow?
>
> Woltore
>
>
|
|
|
|
|