Structural exception issue

[former_member201987]

Hello Experts,

We are sending data from ECC via outbound proxy via PI to MDM 7.1 system. Below is the message structure as extracted from PI.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_IB_CUSTOMER_CONVERSION xmlns:ns0="http://tycofp.com/MDMCustomerProxyObjects">

- <Customer_Details>

<Customer_Number>0000000807</Customer_Number>

<Account_Group>Z001</Account_Group>

<UIN>Test VAI001</UIN>

<Country_Code>US</Country_Code>

<Transportation_Zone_Code>Z000000001</Transportation_Zone_Code>

<Country_Description>USA</Country_Description>

<Transportation_Zone_Description>TZone</Transportation_Zone_Description>

</Customer_Details>

</ns0:MT_IB_CUSTOMER_CONVERSION>

We have uploaded the schema XSD by converting the xml file dumped in the ready folder of the MDM port to XSD via an online converter. Below is the XSD structure:

- <xs:schema id="MT_IB_CUSTOMER_CONVERSION" targetNamespace="http://abc.com/MDMCustomerProxyObjects" xmlns:mstns="http://tycofp.com/MDMCustomerProxyObjects" xmlns="http://abc.com/MDMCustomerProxyObjects" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified" msdata:schemafragmentcount="2">

- <!-- Generated using Flame-Ware Solutions XML-2-XSD v2.0 at http://www.flame-ware.com/Products/XML-2-XSD/

-->

- <xs:element name="MT_IB_CUSTOMER_CONVERSION" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:Prefix="ns0">

- <xs:complexType>

- <xs:choice minOccurs="0" maxOccurs="unbounded">

- <xs:element name="Customer_Details" form="unqualified">

- <xs:complexType>

- <xs:sequence>

<xs:element name="Customer_Number" form="unqualified" type="xs:string" minOccurs="0" />

<xs:element name="Account_Group" form="unqualified" type="xs:string" minOccurs="0" />

<xs:element name="UIN" form="unqualified" type="xs:string" minOccurs="0" />

<xs:element name="Country_Code" form="unqualified" type="xs:string" minOccurs="0" />

<xs:element name="Transportation_Zone_Code" form="unqualified" type="xs:string" minOccurs="0" />

<xs:element name="Country_Description" form="unqualified" type="xs:string" minOccurs="0" />

<xs:element name="Transportation_Zone_Description" form="unqualified" type="xs:string" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>

We prepared the import map by selecting XML Schema in import manager and then selecting the above mentioned schema.

In the above structure we want to map the transportation zone corresponding to the country for each customer. For that we have partitioned the Country_Description field and added the Transportation_Zone_Description under it to create a hierarchy structure, so that we can map it to the MDM transportation zone hierarchy table values.

But while importing it gives a structural exception and the port gets blocked.

Please help!

Thanks

~ Suraj

[former_member201987]

Hello All,

The Problem got solved automatically after restarting the MDM server. Dont know how or why.

Thanks,

Suraj

[Former Member]

Hi SUraj

For the failed xml file plese connect to the exception folder via Import manager and manually check whats the error message in the Import status tab.

After resolving the error use Save update option for saving the import map.

Hope this helps-Ravi

[former_member201987]

Hello Ravi,

When we manually imort the file in exception In imort manager it does not show any error. It says "Ready for Import".

And when imported gets imported successfully. When again we send a file via proxy it goes into structural exception.

Thanks,

Suraj

[former_member201987]

Below is the incoming xml file structure

<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_IB_CUSTOMER_CONVERSION xmlns:ns0="http://abc.com/MDMCustomerProxyObjects"><Customer_Details><Customer_Number>0000000724</Customer_Number><Account_Group>KTOK</Account_Group><Country_Code>IN</Country_Code><Transportation_Zone_Code>Z000000000</Transportation_Zone_Code><Country_Description>India</Country_Description><Transportation_Zone_Description>India: All Cities</Transportation_Zone_Description></Customer_Details><Customer_Details><Customer_Number>0000000805</Customer_Number><Account_Group>KTOK</Account_Group><Country_Code>IN</Country_Code><Transportation_Zone_Code>Z000000001</Transportation_Zone_Code><Country_Description>India</Country_Description><Transportation_Zone_Description>TZone</Transportation_Zone_Description></Customer_Details><Customer_Details><Customer_Number>0000000806</Customer_Number><Account_Group>KTOK</Account_Group><UIN>Test VAI001</UIN><Country_Code>US</Country_Code><Transportation_Zone_Code>Z000000001</Transportation_Zone_Code><Country_Description>USA</Country_Description><Transportation_Zone_Description>TZone</Transportation_Zone_Description></Customer_Details></ns0:MT_IB_CUSTOMER_CONVERSION>

Thanks,

Suraj

[former_member201987]

Below is the xsd that we have uploaded

<xs:schema id="MT_IB_CUSTOMER_CONVERSION" targetNamespace="http://abc.com/MDMCustomerProxyObjects" xmlns:mstns="http://abc.com/MDMCustomerProxyObjects" xmlns="http://abc.com/MDMCustomerProxyObjects" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified" msdata:schemafragmentcount="2"><!-- Generated using Flame-Ware Solutions XML-2-XSD v2.0 at http://www.flame-ware.com/Products/XML-2-XSD/ -->  <xs:element name="MT_IB_CUSTOMER_CONVERSION" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:Prefix="ns0"><xs:complexType><xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="Customer_Details" form="unqualified"><xs:complexType><xs:sequence><xs:element name="Customer_Number" form="unqualified" type="xs:string" minOccurs="0" /><xs:element name="Account_Group" form="unqualified" type="xs:string" minOccurs="0" /><xs:element name="UIN" form="unqualified" type="xs:string" minOccurs="0" /><xs:element name="Country_Code" form="unqualified" type="xs:string" minOccurs="0" /><xs:element name="Transportation_Zone_Code" form="unqualified" type="xs:string" minOccurs="0" /><xs:element name="Country_Description" form="unqualified" type="xs:string" minOccurs="0" /><xs:element name="Transportation_Zone_Description" form="unqualified" type="xs:string" minOccurs="0" /></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema>

Sorry for pasting in separate posts. Could not get it into one.

Thanks,

Suraj

[Former Member]

Hi Suraj,

As you have both XSD and XML file available.

Please validate this XML file against this XSD using Altova or XMLSPY tools etc.

Regards,

Mandeep Saini

[Former Member]

Hi Suraj,

Try to import the failed XML from the port directly and check in the import manager, if there are any un mapped fields or values.