XML file created with no proper ordering open and close tags

thupallireddy · Post by **thupallireddy** » Wed Jun 11, 2014 7:43 am

This is happening in live with more data in XML assembly editor stage in 8.5. the below thing happens in sequence. Job is not aborting and crating the xml file. out of 7000 products only 5 or 6 products are getting this error while validating against the XSD. Please suggest me how to overcome this.

<Products>
<Product>
<ExternalId>af411394</ExternalId>
<Name>G&G Active Woven Track Bottoms</Name>
<Description><li>Ideal for sports activities, these woven track bottoms from the F&F Active range have a part mesh lining for comfort with two side pockets and practical reflective trims to the side.</li><li>Elasticated waistband</li><li>Full length</li></Description>
<Descriptions>
<Description locale="loc"><li>Ideal for sports activities, these woven track bottoms from the F&F Active range have a part mesh lining for comfort with two side pockets and practical reflective trims to the side.</li><li>Elasticated waistband</li><li>Full length</li></Description>
<BrandExternalId>GGActive</BrandExternalId>
<CategoryExternalId>kids-sportswear</CategoryExternalId>
<ProductPageUrl>http://ppe.f-f.com/ie/product/GG20Activ ... uctPageUrl>
<ProductPageUrls>
<ProductPageUrl locale="loc">http://ppe.com/ie/product/FF20Active20W ... uctPageUrl>
</ProductPageUrls>
<ImageUrl>http://i1.adis.ws/s/tesco/af411394_is.j ... </ImageUrl>
<ImageUrls>
<ImageUrl locale="loc">http://i1.adis.ws/s/tesco/af411394_is.j ... </ImageUrl>
</ImageUrls>
<EANs>
<EAN>5053526319724</EAN>
</EANs>
<Names>
<Name locale="loc">G&g Active Woven Track Bottoms</Name>
</Names>
</Descriptions>
</Product>
*************************************************************************************
correct one
******************************************************************************************
<Product>
<ExternalId>bk311115</ExternalId>
<Name>F&F Limited Edition Metallic Heel Stiletto Court Shoes</Name>
<Description><li>Add a glamorous edge to your wardrobe with these F&F Limited Edition stiletto court shoes. These striking pointed toe courts have an animal print in a glossy patent finish and a brushed metal effect stiletto heel.</li><li>Slip on</li><li>Heel height: 10cm</li></Description>
<Descriptions>
<Description locale="loc"><li>Add a glamorous edge to your wardrobe with these F&F Limited Edition stiletto court shoes. These striking pointed toe courts have an animal print in a glossy patent finish and a brushed metal effect stiletto heel.</li><li>Slip on</li><li>Heel height: 10cm</li></Description>
</Descriptions>
<BrandExternalId>GGLimitedEdition</BrandExternalId>
<CategoryExternalId>new-in-sale-wm</CategoryExternalId>
<ProductPageUrl>http://ppe.com/ie/product/GG20Limited20 ... uctPageUrl>
<ProductPageUrls>
<ProductPageUrl locale="loc">http://ppe.com/ie/product/FF20Limited20 ... uctPageUrl>
</ProductPageUrls>
<ImageUrl>http://i1.adis.ws/s/tesco/bk311115_is.j ... </ImageUrl>
<ImageUrls>
<ImageUrl locale="loc">http://i1.adis.ws/s/test/bk311115_is.jp ... </ImageUrl>
<</ImageUrls>

<Name locale="loc">F&F Limited Edition Metallic Heel Stiletto Court Shoes</Name>
< </Names>
</Product>

chulett · Post by **chulett** » Wed Jun 11, 2014 8:02 am

Can you be more specific about what "this error" is that you get for 5 or 6 products? And also specifically point out the differences in the two examples that are the issue? Not really seeing an issue with the "opening and closing tags" themselves.

thupallireddy · Post by **thupallireddy** » Wed Jun 11, 2014 9:25 am

Hi chulett,

My requirement is like this.

<Descriptions>
<Description locale="loc"><li>Add a glamorous edge to your wardrobe with these F&F Limited Edition stiletto court shoes. These striking pointed toe courts have an animal print in a glossy patent finish and a brushed metal effect stiletto heel.</li><li>Slip on</li><li>Heel height: 10cm</li></Description>
</Descriptions>

But I am getting the closed tag of Descriptions in different position as specified above. Please help me to overcome this

qt_ky · Post by **qt_ky** » Wed Jun 11, 2014 9:43 am

Oh, I see now in the first example, the </Descriptions> tag is not where you expected to find it. Is the XML coming to your job in that way, or do you have a job producing it in that way?

eostic · Post by **eostic** » Wed Jun 11, 2014 12:40 pm

Hard to say, but one would suspect that Description is at two different levels in the xsd. One at the level of Name and another is within a list called Descriptions.

thupallireddy · Post by **thupallireddy** » Wed Jun 11, 2014 10:58 pm

Hi Eric,

There is a job producing XML based on XSD. It worked fine in test and preprod but in live it is giving problem for 5 or 6 items randomly. I checked wheteher there is any data issue. But no issues and tried to run the job couple of times and this mismatch of close tag is happening randomly. So i thought to change both the heapsize and stack size in xml stage from 256 to 1024 or 2048. But still no use

. Please let me know how to overcome this.

thupallireddy · Post by **thupallireddy** » Wed Jun 11, 2014 11:00 pm

Hi Ernie,

Yes there is Descriuptions tag with list and description containing in it. For differnet locales teh information should be residing in description. It should be like below.

Code: Select all

<Descriptions>
   <Description locale="loc1"> ....</Description>
   <Description locale="loc2"> ....</Description>
</Descriptions>

eostic · Post by **eostic** » Thu Jun 12, 2014 4:52 am

Does Description appear only once in your entire xsd ?

I haven't seen the stage write the structure incorrectly. Anything's possible, of course.

Nothing is random. Try to determine if only "those rows" cause the issue.

If the xsd is huge, you might want to try schema views but it's too early to suggest that.

Ernie

thupallireddy · Post by **thupallireddy** » Fri Aug 22, 2014 7:54 am

It Appears for every product in xml. Please let me know whether any fix pack needs to upgrade for the same. Currently im using 8.5 with fixpack2.

Because it is working fine for 1000 products and if it is 3000, then issue is arising for each chunk. chunk contains product_id, desc, locale etc., Randomly xml is generated with no proper close tags.

correct:
<Product>
<ExternalId>p1</ExternalId>
<CategoryExternalId>online-exclusives</CategoryExternalId>
<Names>
<Name locale="au">name_au</Name>
<Name locale="nz">name_nz</Name>
</Names>
<Descriptions>
<Description locale="au">desc_au</Description>
<Description locale="nz">desc_nz</Description>
</Descriptions>
<ProductPageUrls>
<ProductPageUrl locale="au">http://url/p1</ProductPageUrl>
<ProductPageUrl locale="nz">http://url/p1</ProductPageUrl>
</ProductPageUrls>
<UPCs>
<UPC>9956896987451</UPC>
<UPC>8609050509613</UPC>
</UPCS>
</Product>

wrong:

<Product>
<ExternalId>p1</ExternalId>
<CategoryExternalId>online-exclusives</CategoryExternalId>
<Names>
<Name locale="au">name_au</Name>
<Name locale="nz">name_nz</Name>
</Names>
<Descriptions>
<Description locale="au">desc_au</Description>
<Description locale="nz">desc_nz</Description>
<UPCs>
<UPC>9956896987451</UPC>
<UPC>8609050509613</UPC>
</UPCS>
<ProductPageUrls>
<ProductPageUrl locale="au">http://url/p1</ProductPageUrl>
<ProductPageUrl locale="nz">http://url/p1</ProductPageUrl>
</ProductPageUrls>
<UPCs>
<UPC>9956896987451</UPC>
<UPC>8609050509613</UPC>
</UPCS>
</Descriptions>
</Product>

Please let me know how to overcome this in xml stage. Job is running fine with out any errors and randomly this tags are happening only for 3 to 5 products. If we run run job once again, same products(error products) are not repeated in newxml. This shows there is no data issues.