Couldn't able to read xml file
Posted: Fri Aug 17, 2012 8:02 am
Hi ,
I am trying to read xml file and load it into text file .
I used External Source->xml input->transformer->sequential file
In External Source , i Have specified
Source Method as Specific Program
Source program as ls /abc/ghe/books.xml
Record Type as implicit
Record delimiter as none
In Xml input stage , i have specified url/filepath in input tab
When i ran the job i got the below error
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=/abc/ghe/books.xml
The sample xml is as follows
<x:books xmlns:x="urn:books">
<book id="bk001">
<author>Writer</author>
<title>The First Book</title>
<genre>Fiction</genre>
<price>44.95</price>
<pub_date>2000-10-01</pub_date>
<review>An amazing story of nothing.</review>
</book>
<book id="bk002">
<author>Poet</author>
<title>The Poet's First Poem</title>
<genre>Poem</genre>
<price>24.95</price>
<review>Least poetic poems.</review>
</book>
</x:books>
Could anyone please help me out in resolving this issue
I am trying to read xml file and load it into text file .
I used External Source->xml input->transformer->sequential file
In External Source , i Have specified
Source Method as Specific Program
Source program as ls /abc/ghe/books.xml
Record Type as implicit
Record delimiter as none
In Xml input stage , i have specified url/filepath in input tab
When i ran the job i got the below error
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=/abc/ghe/books.xml
The sample xml is as follows
<x:books xmlns:x="urn:books">
<book id="bk001">
<author>Writer</author>
<title>The First Book</title>
<genre>Fiction</genre>
<price>44.95</price>
<pub_date>2000-10-01</pub_date>
<review>An amazing story of nothing.</review>
</book>
<book id="bk002">
<author>Poet</author>
<title>The Poet's First Poem</title>
<genre>Poem</genre>
<price>24.95</price>
<review>Least poetic poems.</review>
</book>
</x:books>
Could anyone please help me out in resolving this issue