| Neal Walters 2004-12-13, 6:28 pm |
| I am trying to call a stored procedure that in turns calls an SQL Bulk Load.
Based on files created on the file system, I know it is getting called.
The stored procedure returns data as follows:
INSERT
INTO @ReturnTable
SELECT @Return AS ReturnValue
, @ReturnMessage AS ReturnMessage
SELECT *
FROM @ReturnTable AS Results
FOR XML AUTO, ELEMENTS
I custom built by schema for the SQL rather than using the SQL Adapter.
Because of the error below, I have tried to simplify and simplify until the
error goes away - but that has not worked.
------------------------------------------------------------------------------------
Microsoft.XLANGs.Core.UnexpectedMessageTypeException: Received unexpected
message type '' does not match expected type
'http://Odimo.com/Amazon/SettlementBulkLoad#BulkLoadSQLResp'.
at
Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.VerifyTransport(Envelope env,
Int32 operationId, Context ctx)
at Microsoft.XLANGs.Core.Subscription.Receive(Segment s, Context ctx,
Envelope& env, Boolean topOnly)
at Microsoft.XLANGs.Core.PortBase.GetMessageId(Subscription subscription,
Segment currentSegment, Context cxt, Envelope& env, CachedObject location)
at Odimo.Amazon.Settlement.orSettlement.segment1(StopConditions stopOn)
at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s,
StopConditions stopCond, Exception& exp)
Microsoft.XLANGs.Core.UnexpectedMessageTypeException
Scoped@
orSettlement.orSettlement
------------------------------------------------------------------------------------
My SQL schema has two root elements:
BulkLoadSQLReq and BulkLoadSQLResp
Under the BulkLoadSQLResp I have simplified to the <ANY> element, so that I
could try to avoid the error totally.
In my Send Port (Request/Response) I have set
root element name to: BulkLoadSQLResp
and target namespace to: http://Odimo.com/Amazon/SettlementBulkLoad
(which matches the namespace of the schema).
Thanks a lot,
Neal Walters
http://Biztalk-Training.com - Free Biztalk Demos
|