|
Home > Archive > BizTalk Server > June 2007 > SQL Adapter -No Disassemble stage components can recognize the data
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 |
SQL Adapter -No Disassemble stage components can recognize the data
|
|
|
| Friends,
I have been getting the "No Disassemble stage components
can recognize the data"
error when i am trying to update a table in a sql server 2005 using the
sql adapter from an orchestration.The wierd part is that the same
orchestration was working a few days back, the server where i am
testing the orchestration is a Test one and i suspect the problem may
have been caused by some changes my co-developer did when he ran a Best
Practices Analyzer on the server.If anybody can help me on this that
will be great.
| |
| Michael Elizarov [MSFT] 2006-07-21, 1:20 am |
| All pipelines have a number of stages. One of the stages for receive
pipeline is disassemble. You can specify a number of the components that
can be executed at that stage, and each of them will be given a stream to
probe and say if component can handle it. If none of the components are
capable fo handling the stream, you will get the error you are describing.
You can get this kind of error if, for example, you are using XML pipeline
on a non-XML stream. Take a look at your pipeline on that receive location.
-- Michael
--------------------[vbcol=seagreen]
| |
| vijaya 2007-06-28, 1:18 pm |
|
> Friends,
> I have been getting the "No Disassemble stage components
> can recognize the data"
> error when i am trying to update a table in a sql server 2005 using the
> sql adapter from an orchestration.The wierd part is that the same
> orchestration was working a few days back, the server where i am
> testing the orchestration is a Test one and i suspect the problem may
> have been caused by some changes my co-developer did when he ran a Best
> Practices Analyzer on the server.If anybody can help me on this that
> will be great.
Hi
Iam using a request response port with sql adapter.
In my orchestration iam calling a stored proc to get data.i used default xml transmit and default xml receive to send request and receive response from sql. Iam getting the following error
There was a failure executing the receive pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive" Source: "XML disassembler" Receive Location: "SQL://xxxxxxx/xxxxxxx/" Reason: None of the components at Disassemble stage can recognize the data.
It was failing in the first reqest/Resp call to sql it self. If this suceeds it should be mapped to another schema generated from stored proc so on ..
Not sure why it is giving error.Can some one guide me in right direction
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities
| |
| Jan Eliasen 2007-06-28, 7:17 pm |
| On Thu, 28 Jun 2007 17:07:08 GMT, "vijaya"<nvijaya1@gmail.com> wrote:
>In my orchestration iam calling a stored proc to get data.i used default xml transmit and default xml receive to send request and receive response from sql. Iam getting the following error
>There was a failure executing the receive pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive" Source: "XML disassembler" Receive Location: "SQL://xxxxxxx/xxxxxxx/" Reason: None of the components at Disassemble stage can recognize the data.
>It was failing in the first reqest/Resp call to sql it self. If this suceeds it should be mapped to another schema generated from stored proc so on ..
>
>Not sure why it is giving error.Can some one guide me in right direction
What does your stored procedure look like? Does it have a select
statement with the "for xml auto" at the end? Or perhaps it has more
than one select statement? That wont work unless you have the SET
NOCOUNT ON; set in the SP.
--
eliasen, representing himself and not the company he works for.
Private blog: http://blog.eliasen.dk
Private email: jan@eliasen.dk
|
|
|
|
|