DSXchange

Hi

I have a design like below

oracle_connector ---> copy----> xmlinput--- > t/f----->oracle_connector

We are reading xml from oracle CLOB and parsing the xml using xml input stage. Job ran fine for couple of xmls but for one of the xmls I am facing xalan fatal error, which is basically occurs due to discrepancies in xml structure. i have tested the xml with altova and it is well formed and valid.

the error message is "XML document parsing failed: Xalan Fatal error: Expected an attribute value."

xml input properties i have given: repetition element required, replace nulls with values, fragment, reading xml document.

please help me here.

It may be "well formed and valid" but it sounds like it doesn't match the metadata (XPath Expressions) you are using to parse it. Does all of the XML in the CLOB conform to a single xsd?

The Xpath expressions are fine craig. I have taken the copy of CLOB XML and ran it through External source as a file and it is loading successfully. i don't know why it is not working through CLOB.

/Does all of the XML in the CLOB conform to a single xsd?/

yes it does.

OK, then perhaps something extra is coming along for the ride. How exactly are you extracting the XML from the CLOB in the job? Doing anything other than just selecting it?

It has been solved mate.. I have increased the length of the CLOB column and it is loading fine now.. my bad.. thanks for your reply anyway..!