XML pasing issue

[bkar]

Hi,

I'm trying to parsing XML document to tabular data, for that I'm using
Folder stage --> XML Input --> Oracle Table.

I'm getting a runtime error as below

XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:\IBM\InformationServer\Server\Projects\project_name/.

I have checked include namespace declaration in XML input stage properties and have below entries...

xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:ns1="http://xmlns.oracle.com/apps/otm"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

Thanks
Bibek

[eostic]

Hard to say.

a) make sure that Folder is doing what you want it to. Are you using the default "builtIn" table defintion for the output link of the Folder Stage?

b) send the columns from folder thru a transformer and then send the filename to a file. make sure it looks good.

c) in the xmlInput Stage, select Record from the pulldown of columns, and choose "XML Document" radio button and NOT the URL button.

For now we'll assume that you have imported your metadata via xsd or the xml document itself, and loaded that to the output link, and chose a repeating element.

Ernie