Issue with XML input stage

rudrakshalas · Post by **rudrakshalas** » Mon May 26, 2014 4:53 am

Hi,

I have imported XML table definition using Import->table definitions->xml table definitions from XML file.

Later my job design is like this:

sequential file -> XML input stage -> dataset

Sequential file: URL of XML file in a text file and calling it in this stage
XML input stage: XML source: URL/file path selected
output loaded columns from table definition downloaded
Transformation setting loaded included name space declaration and selected the XML file.
Given one key column in output columns.

Dataset : Given dataset name.

I am new in handling XML data. Getting an error. Below is the errror:

" APT_CombinedOperatorController,0: Fatal Error: Fatal: 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:\GIDMetrics\Batch\OutputR2\MSP\03_12_306_5.xml
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:\GIDMetrics\Batch\OutputR2\MSP\03_12_306_5.xml "

Could you please help me in resolving the issue and suggest a solution please.

Do we need XSD file to process the XML file, even if I have table definition.

Thanks in advance.

chulett · Post by **chulett** » Mon May 26, 2014 7:55 am

All your error is saying at the moment is that your XML file cannot be found. Is that path correct and does the user your job runs under have the proper permissions required to read it?

soumya5891 · Post by **soumya5891** » Mon May 26, 2014 1:22 pm

Is the datastage running on MPP configuration?

chulett · Post by **chulett** » Mon May 26, 2014 5:21 pm

Windows MPP?

rudrakshalas · Post by **rudrakshalas** » Mon May 26, 2014 10:36 pm

Yes our server is a 2box machine, and datastage is installed on Windows OS

chulett · Post by **chulett** » Tue May 27, 2014 12:52 am

That doesn't make it Massively Parallel... how about answering my first question? The second was somewhat rhetorical. However, on the chance that your topology is an issue please clarify for us what you mean by "two box machine".

rudrakshalas · Post by **rudrakshalas** » Tue May 27, 2014 1:15 am

" APT_CombinedOperatorController,0: Fatal Error: Fatal: 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\GIDMetrics/03_12_42_122.xml
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\GIDMetrics/03_12_42_122.xml "

Above is my new error while analyzing previous error, I have specified the path something different and I dont know why it is searching in the path in the error.

So when I tried to place the file where the error is showing, my job ran fine and able to see the data in target dataset.
But the thing is that it is not the correct path where I will get file.

Could you please help me

eostic · Post by **eostic** » Tue May 27, 2014 4:52 am

I've seen that before, and can't recall if it was only with parallel Jobs or only with Server Jobs. Seems to me that it worked in one and not in the other.

If you don't need massive parallelism or QualityStage, try a Server Job. Instead of feeding the URL for the file via the External Source Stage, feed in either the whole xml document or the location of it via the Folder Stage.

...if it is already a Server Job, try it with an EE Job, using the External Source Stage to feed in the location...

Ernie