Re: BizTalk Mapping not working!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.


.

Relevant Pages

  • Re: Flat File Problem
    ... It was the namespace I was using to ... When I debug the orchestration the RecCount variable is null. ... Have you deployed the Biztalk Assembly that contains the property schema ... And you can promote properties from the Header into the message context, ...
    (microsoft.public.biztalk.general)
  • Schema versioning / namespace or no namespace / like root nodes / Pipelines - any ideas?
    ... Namespace Options: Trying to figure out which way to go... ... I'm planning to handle the varying levels of schema content being ... Pipeline component to add this namespace to incoming SAP docs. ... pipeline per assembly-version (since there's no need for the pipeline ...
    (microsoft.public.biztalk.general)
  • Re: Re: Re: SQLXML Namespaces
    ... > namespace, so SQLXML has declared an arbitrary prefix for the ... > the results you can declare any prefix you like and the XML ... >> Your schema must have a default or target namespace ...
    (microsoft.public.sqlserver.xml)
  • Re: Message type conversion from C# object to BizTalk message
    ... Originally I didn't know what you meant, but of course in BizTalk there are ... Properties) when you simply click once on the schema file and have the ... The second namespace is the targetNamespace in the ...
    (microsoft.public.biztalk.general)
  • Re: Best place to use AND how to validate a Version
    ... I like the idea of using versions in the namespace. ... the datatypes schema was seperate from the message schema. ... >>embed versioninfo in the XML namespace as: ...
    (microsoft.public.dotnet.framework.webservices)