XML File read warning
Posted: Mon Dec 08, 2008 11:08 pm
I am reading xml file data and writing it to the sequential file. The job design is External Source Stage-->XML Input Stage-->Sequential File.
Source program path mentioned in External SOurce Stage is ls \\Svkcdisd01\Projects\EDW\Outputs\sample.xml-----and it is returning me one row in the output column. Then in XML input stage, I checked on URL?File Path and gave Repetition element also. When I am running my job, there is one record goes from External Source Stage to XML input, but no rows flow after XML stage. I am getting the warning message:
XML_Input_1,0: Warning: xml_test1.XML_Input_1: 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\EDW///Svkcdisd01/Projects/EDW/Outputs/sample.xml
Structure of xml file :
<?xml version="1.0" ?>
- <customers>
- <customer id="55000">
<name>Charter Group</name>
- <address>
<street>100 Main</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
- <address>
<street>720 Prospect</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
- <address>
<street>120 Ridge</street>
<state>MA</state>
<zip>01760</zip>
</address>
</customer>
</customers>
Please give any suggestions..
Thanks,
Source program path mentioned in External SOurce Stage is ls \\Svkcdisd01\Projects\EDW\Outputs\sample.xml-----and it is returning me one row in the output column. Then in XML input stage, I checked on URL?File Path and gave Repetition element also. When I am running my job, there is one record goes from External Source Stage to XML input, but no rows flow after XML stage. I am getting the warning message:
XML_Input_1,0: Warning: xml_test1.XML_Input_1: 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\EDW///Svkcdisd01/Projects/EDW/Outputs/sample.xml
Structure of xml file :
<?xml version="1.0" ?>
- <customers>
- <customer id="55000">
<name>Charter Group</name>
- <address>
<street>100 Main</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
- <address>
<street>720 Prospect</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
- <address>
<street>120 Ridge</street>
<state>MA</state>
<zip>01760</zip>
</address>
</customer>
</customers>
Please give any suggestions..
Thanks,