RE: SQL Adapter and Pipeline envelope processing
- From: "Suneet Nangia"<suneetmohan@xxxxxxxxx>
- Date: Mon, 16 Oct 2006 21:29:41 GMT
I'm using BizTalk 2006 Beta 2 and am trying the SQL Adapter to read in
a set of records using a stored procedure and use a custom pipeline
using the XMLDissambler to create individual messages using envelope
processing I keep getting the error below and have no idea how to fix
it.
Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5719
Date: 4/5/2006
Time: 10:06:44 PM
User: N/A
Computer: BTS2006B2
Description:
There was a failure executing the receive pipeline:
"SQLDemo.SQLReceiveShipments, SQLDemo, Version=1.0.0.0,
Culture=neutral, PublicKeyToken=810c5c88fdf126db" Source: "Pipeline "
Receive Port: "GetShipmentsFromDB" URI: "SQL://BTS2006B2/Test/" Reason:
Unexpected event ("document_start") in state
"processing_empty_document".
The 2 schemas are:
Envelope:
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003";
xmlns="http://SQLDemo.GetShipments";
targetNamespace="http://SQLDemo.GetShipments";
xmlns:xs="http://www.w3.org/2001/XMLSchema";>
<xs:annotation>
<xs:appinfo>
<b:schemaInfo is_envelope="yes"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"; />
</xs:appinfo>
</xs:annotation>
<xs:element name="Shipments">
<xs:annotation>
<xs:appinfo>
<b:recordInfo body_xpath="/*[local-name()="Shipments" and
namespace-uri()="http://SQLDemo.GetShipments"]"; />
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:any namespace="##any" processContents="lax" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Document:
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003";
attributeFormDefault="unqualified" elementFormDefault="qualified"
targetNamespace="http://SQLDemo.GetShipments"; version="1.0"
xmlns:xs="http://www.w3.org/2001/XMLSchema";>
<xs:annotation>
<xs:appinfo>
<msbtssql:sqlScript value="exec [GetShipments]"
xmlns:msbtssql="http://schemas.microsoft.com/BizTalk/2003"; />
</xs:appinfo>
</xs:annotation>
<xs:element xmlns:q1="http://SQLDemo.GetShipments"; name="Shipment"
type="q1:ShipmentType" />
<xs:complexType name="ShipmentType">
<xs:attribute name="ShipmentID" type="xs:int" />
<xs:attribute name="Shipper" type="xs:string" />
<xs:attribute name="DestinationCity" type="xs:string" />
<xs:attribute name="DeliveryDate" type="xs:string" />
<xs:attribute name="LastUpdateDate" type="xs:string" />
</xs:complexType>
</xs:schema>
You can have a look at my blog which shows something similar. hope that helps...
http://suneetnangia.spaces.live.com/blog/
Posted from http://www.topxml.com/renntp using reNNTP: the website based NNTP reader.
.
- Prev by Date: SQL Adapter Envelope Processing
- Next by Date: RE: Message Box
- Previous by thread: SQL Adapter Envelope Processing
- Next by thread: RE: Installation Error 1928
- Index(es):
Relevant Pages
|
Loading
