|
Home > Archive > BizTalk Server Orchestration > November 2004 > Dynamic SQL Solicit-Response Port
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 |
Dynamic SQL Solicit-Response Port
|
|
| Josef Dubisar 2004-05-30, 10:47 am |
| Hello,
I have a problem with Dynamic SQL port in orchestration. I set something like Port_SQL(Microsoft.XLANGs.BaseTypes.Address)="SQL://sqlserver/database/" and to this port I send a message with the schema corresponding to my Request schema of SQL Adapter. The
Stored procedure is called ok, but I can't get the result back. I get an error in EventLog instead: "There was a failure executing the receive pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive" Source: "XML disassembler" Receive Location: "SQL://m
yserver/mydatabase/" Reason: None of the components at Disassemble stage can recognize the data."
I suspect, that the Namespace and the Response Root Element Name are not set correctly, but I don't know how to set them on the dynamic port.
Thank you in advance for any help,
JD.
| |
| mganio 2004-11-29, 8:22 am |
| Hi,
i'm getting same error in a quite-similar scenario: I'm posting on HTTPReceive an XML constructed by Schema Editor (so, i think it's adherent enought to the Schema used to generate it).
Sincerely, I can't find out a reason for this error which i havn't understood so well.
Do you find out a solution to your problem? Please, note that you are one of the few reportng this error in Internet.
Thank you,
Marco Ganio V. |
|
|
|
|