XML Parsing error, XALAN Fatal Error, expected an attribute

saidutta123 · Post by **saidutta123** » Thu Sep 29, 2011 11:28 pm

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.

chulett · Post by **chulett** » Thu Sep 29, 2011 11:37 pm

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?

saidutta123 · Post by **saidutta123** » Fri Sep 30, 2011 1:36 am

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.

chulett · Post by **chulett** » Fri Sep 30, 2011 6:50 am

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?

saidutta123 · Post by **saidutta123** » Fri Sep 30, 2011 7:28 am

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..!