I am developing a simple parallel job which involves a xml input file
Sample input data
===========
<xml>
<ID>I7-1</ID>
<ID>I7-2</ID>
</xml>
Job design:
External source-->XML_Input--->SEq file
Settings:
External source:
==========
Properties:
source Method: Specific program(s)
Source program: ls /home/sample.xml
Format:
Record type :Implicit
Delimiter:None
Columns:
Defined one column 'Filename' of VarChar type, Non-Nullable and din't specified the length
XML INPUT STAGE:
=============
Stage->Transformation Settings
checked 'Repitition element required'
input-->XML Source
in XML Source Column selected 'Filename' column which i have defined in External source stage
&
checked 'XML document'
output -->columns
defined a column 'Id', derivation-left blank,Key-Yes,SQL type-Varchar,Nullable-->No, Description-->/xml/customer/text()
1.Checked whether the xml is opening properly in internet explorer
2.Able to see the filename with path, when i do view data in External source stage
when i ran the job, the job is finishing successfully but no records got loaded into the target file.
But got one warning as below
Code: Select all
XML_Input_3,0: Warning: Xml.XML_Input_3: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure
input-->XML Source
checked 'URL/File Path'
Even now job finished successfully bot no rows in output and got the below warning
Code: Select all
XML_Input_3,0: Warning: Xml.XML_Input_3: 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=/home/sample.xml
Your help would be appreciated and thanks in advance
Regards,
Raja R P