Issue with XML input
Posted: Wed Feb 15, 2012 2:18 pm
Hi all,
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
Then change one setting in XML input stage
input-->XML Source
checked 'URL/File Path'
Even now job finished successfully bot no rows in output and got the below warning
Sorry for the long post.But wanted to give you people a clear picture.
Your help would be appreciated and thanks in advance
Regards,
Raja R P
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