Alright, I am done breaking my head now! I have an extremely simple
orchestration that does the following:-
1. Receives an XML file (FILE port)
2. Transforms to an output schema
3. Write the output file to disk (FILE port)

The output XML file does not contain any data in it, all it contains is a
skeleton of the schema as follows :-->
<?xml version="1.0" encoding="utf-8"?><ns0:OrderOutput
xmlns:ns0="http://BTPlayGround.OrdersOutputFile"></ns0:OrderOutput>

I don't see any event logs, checked my mapping more than once, but couldn't
find any issue with it. FYI i'm posting my input and output schemas here :-


INPUT:
=====

<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns="http://BTPlayGround.OrdersInput"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://BTPlayGround.OrdersInput"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="CustomerPurchase">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="1" name="Orders">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Order">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:int" />
<xs:element name="Price" type="xs:decimal" />
<xs:element name="Prod_Type" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element maxOccurs="1" name="Accessories">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Accessory">
<xs:complexType>
<xs:sequence>
<xs:element name="Order_Id" type="xs:int" />
<xs:element name="Accessory_Name" type="xs:string" />
<xs:element name="Price" type="xs:decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

OUTPUT:
======
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns="http://BTPlayGround.OrdersRelational"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://BTPlayGround.OrdersRelational"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="InOrdersData">
<xs:complexType>
<xs:sequence>
<xs:element name="sync">
<xs:complexType>
<xs:sequence>
<xs:element name="after">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Orders">
<xs:complexType>
<xs:sequence>
<xs:element name="OrderId" type="xs:string" />
<xs:element name="AccessoryCount" type="xs:string" />
<xs:element name="TotalPrice" type="xs:string" />
<xs:element name="ProductType" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element maxOccurs="unbounded" name="OrderAccesories">
<xs:complexType>
<xs:sequence>
<xs:element name="OrderId" type="xs:string" />
<xs:element name="AccessoryIndex" type="xs:string" />
<xs:element name="Description" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="OutOrdersData">
<xs:complexType>
<xs:sequence>
<xs:element name="Success" type="xs:anyType" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Just thought an extra eye on my schema would be helpful.
Any help is highly appreciated,
Thanks,
Sudhir.

[ Post a follow-up to this message ]

Hi Sudhir,

When I compare the namespace of your blank skeleton output message with the
output schema's namespace they don't match.
Looks like your map is creating the wrong message. Try to replace the right
hand schema with your output xsd.

HTH,

Randal van Splunteren
http://biztalkia.blogspot.com

> Alright, I am done breaking my head now! I have an extremely simple
> orchestration that does the following:-
> 1. Receives an XML file (FILE port)
> 2. Transforms to an output schema
> 3. Write the output file to disk (FILE port)
> The output XML file does not contain any data in it, all it contains
> is a
> skeleton of the schema as follows :-->
> <?xml version="1.0" encoding="utf-8"?><ns0:OrderOutput
> xmlns:ns0="http://BTPlayGround.OrdersOutputFile"></ns0:OrderOutput>
> I don't see any event logs, checked my mapping more than once, but
> couldn't find any issue with it. FYI i'm posting my input and output
> schemas here :-
>
> INPUT:
> =====
> <?xml version="1.0" encoding="utf-16" ?>
> <xs:schema xmlns="http://BTPlayGround.OrdersInput"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://BTPlayGround.OrdersInput"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="CustomerPurchase">
> <xs:complexType>
> <xs:sequence>
> <xs:element maxOccurs="1" name="Orders">
> <xs:complexType>
> <xs:sequence>
> <xs:element maxOccurs="unbounded" name="Order">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="ID" type="xs:int" />
> <xs:element name="Price" type="xs:decimal" />
> <xs:element name="Prod_Type" type="xs:string" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element maxOccurs="1" name="Accessories">
> <xs:complexType>
> <xs:sequence>
> <xs:element maxOccurs="unbounded" name="Accessory">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Order_Id" type="xs:int" />
> <xs:element name="Accessory_Name" type="xs:string" />
> <xs:element name="Price" type="xs:decimal" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
> OUTPUT:
> ======
> <?xml version="1.0" encoding="utf-16" ?>
> <xs:schema xmlns="http://BTPlayGround.OrdersRelational"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://BTPlayGround.OrdersRelational"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="InOrdersData">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="sync">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="after">
> <xs:complexType>
> <xs:sequence>
> <xs:element maxOccurs="unbounded" name="Orders">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="OrderId" type="xs:string" />
> <xs:element name="AccessoryCount" type="xs:string" />
> <xs:element name="TotalPrice" type="xs:string" />
> <xs:element name="ProductType" type="xs:string" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element maxOccurs="unbounded" name="OrderAccesories">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="OrderId" type="xs:string" />
> <xs:element name="AccessoryIndex" type="xs:string" />
> <xs:element name="Description" type="xs:string" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="OutOrdersData">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Success" type="xs:anyType" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
> Just thought an extra eye on my schema would be helpful.
> Any help is highly appreciated,
> Thanks,
> Sudhir.

[ Post a follow-up to this message ]

Randal,
Thanks for the reply. My bad, I posted the wrong schema. But I did check
the destination schema in mapper and the one in the output file and they bot
h
look the same. But I still have no clue as to why this is returning an empty
message without any errors. Would posting my mappings file here of any help.
Also, here's my actual destination schema:
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns="http://BTPlayGround.OrdersOutputFile"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://BTPlayGround.OrdersOutputFile"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="OrderOutput">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Orders">
<xs:complexType>
<xs:attribute name="OrderId" type="xs:string" />
<xs:attribute name="AccessoryCount" type="xs:string" />
<xs:attribute name="TotalPrice" type="xs:string" />
<xs:attribute name="ProductType" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element maxOccurs="unbounded" name="OrderAccessories">
<xs:complexType>
<xs:sequence />
<xs:attribute name="OrderId" type="xs:string" />
<xs:attribute name="AccessoryIndex" type="xs:string" />
<xs:attribute name="Description" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Thank you,
Sudhir.

"Randal van Splunteren" wrote:

> Hi Sudhir,
>
> When I compare the namespace of your blank skeleton output message with th
e
> output schema's namespace they don't match.
> Looks like your map is creating the wrong message. Try to replace the righ
t
> hand schema with your output xsd.
>
> HTH,
>
> Randal van Splunteren
> http://biztalkia.blogspot.com
> 
>
>
>

[ Post a follow-up to this message ]