Issue with XML input stage
Posted: 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.
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.