XML file source

system · November 29, 2011, 12:08am

Hello all, I am having trouble getting a DF to work with an XML file source and hope I can explain this clearly.

I have 3 XML files as Source Data, all defined by the same XSD. I created 3 XML Schema Formats, 1 for each Root Element Name. The first and second are working perfectly. The 3rd, however is giving me fits. The Job crashes BODS completely each time I run it- DS just “abnormally” exits. I had the idea that I would try to verify DS can indeed parse my input file so I chose “View Data” on the Source object. This too causes DS to crash.

Using an external tool (Altova XML Spy) I am able to validate all 3 Messages (files) against the XSD, so from this standpoint there is nothing wrong with my data files.

I have deleted my DF and XML Schema definition and started over from scratch 3-4 times with no improvement.

Can anyone suggest a testing methodology or some other way of attempting to pinpoint what is going wrong with my DF? Thank you!

CNV_Ben (BOB member since 2002-08-15)

system · November 29, 2011, 9:33am

First try with single xml file in a data flow which is causing the js to crash.
It would help.

sandeep.kumar (BOB member since 2011-09-28)

system · November 29, 2011, 4:26pm

Basically are the 3 sources contain same type of informational data or they do differ?

ganeshxp (BOB member since 2008-07-17)

system · November 29, 2011, 7:34pm

There are 3 different messages produced at different “stages”. Request, Response, and Status (confirmation). TO Sameer’s point, I have 3 separate Jobs, 1 for each file type. I have also defined 3 separate XML Schemas each using the same XSD but with 3 different values for RootElement. The XML Schema object includes a drop-down from which I can select RootElement, so it is not a case of me typing something incorrectly.

I have a ticket open with SAP support and have forwarded all my Job Logs, XSD, and XML files to them for evaluation and testing.

Thanks again for any guidance or suggestions!

CNV_Ben (BOB member since 2002-08-15)

system · November 30, 2011, 8:25pm

Does anyone know of limitations inherent in BODS which would prevent parsing an XML Message, such as data type or how “deeply nested” Elements are? Can anyone refer me to documentation covering this topic?

Thanks again!

CNV_Ben (BOB member since 2002-08-15)

system · November 30, 2011, 8:32pm

Would you clarify? XML’s as source or XML Messages as source?

ganeshxp (BOB member since 2008-07-17)

system · November 30, 2011, 8:54pm

I am using XML files as source. So, I have defined an XML Schema (Local Object Library/Formats/XML Schemas), then use that as XML File Source in DF. I next Open file source to configure associated XML file, build Query Transform, and write output to SQL Server Table.

The XSD supports multiple Elements; I am working with 3 of these. Two of the 3 parse/run just fine, no problems. Third XML file causes BODS to crash. Same XML file readily validates in XMLSpy. I am running Designer 14.0.1.142.

I have attached XSD and XML file for reference/testing. Thank you!
Problematic_XML_file.zip (7.0 KB)

CNV_Ben (BOB member since 2002-08-15)