XML Input stage

karry450 · Post by **karry450** » Sun Mar 11, 2012 11:59 pm

Hi Team,

I am trying to read an xml file using XML input stage.

My job design is

Job design:
External source-->XML_Input--->SEq file

Settings:

External source:
==========
Properties:
source Method: Specific program(s)
Source program: ls C:\EMP_FILE_Job_Details.xml
Format:
Record type :Implicit
Delimiter:None

Columns:
Defined one column 'Filename' of VarChar type, Non-Nullable and din't specified the length

But I am getting the below error can any one suggest me please

XML_Input_22,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:/EMP_FILE_Job_Details.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:/EMP_FILE_Job_Details.xml

Kirtikumar · Post by **Kirtikumar** » Mon Mar 12, 2012 12:36 am

Please close the other duplicate thread.

I have not used on windows, but directory separator might be the issue here. Are you sure the file is present in the mentioned directory.

eostic · Post by **eostic** » Mon Mar 12, 2012 6:16 am

search the forum and also go here:

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

Don't use the Sequential Stage to read your xml documents.

Ernie

eostic · Post by **eostic** » Mon Mar 12, 2012 6:19 am

sorry...read that too quickly. haven't had my coffee this morning. Check your security for that sub-directory and also look at the encoding. I had a strange one like this recently and when I removed the entire encoding attribute (where it has UTF-8 or similar), it worked.

Ernie

karry450 · Post by **karry450** » Mon Mar 12, 2012 11:55 pm

Hi

Thanks that resolved my problem in accessing xml file but now I am not able to read more than 1 file in a single run.

I have selected the option in external source is

Source Method = Specific programs
Source program= ls E:\ EMP*.xml

I want to read all the xml files that start with EMP in a single run, Can anyone help me if this is possible

chulett · Post by **chulett** » Tue Mar 13, 2012 5:57 am

Yes, that should work just fine. Is your XML Input stage setup to take that filename column as the URL/File path to read the files from?

NL · Post by NL » Tue Mar 13, 2012 11:02 am

Hi,

How did u able to resolve this problem.I am also facing the same issue, plz help me out.

Thanks,
NL

chulett · Post by **chulett** » Tue Mar 13, 2012 1:06 pm

Please start your own post and give us the gory details of your issue there.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 13, 2012 1:50 pm

NL wrote:How did u able to resolve this problem.I am also facing the same issue, plz help me out.

The second person personal pronoun in English is spelled "you", not "u".
There is no word "plz" in English - I suspect you mean "please".
Please strive for a professional standard of written English on DSXchange.

NL · Post by NL » Tue Mar 13, 2012 9:05 pm

I have already posted the topic with subject "Issue in parsing xml file through XML Input Stage".

Thanks