Not Able to read xml file , NLS locale to US-ENGLISH

Selva_dwh · Post by **Selva_dwh** » Fri Nov 27, 2009 9:30 am

Hi,

I am trying to read xml file. And using server job. I am using xml input stage. window xp sp2, DS7.5.2 , server job
and trying to write in a table ( oracle ).

I am getting the error in the folder also.

error details..

DB_job: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH

DB_job..Cust_folder: DSD_DIROpen set &Folder& to "d:\<filename>.xml"

DB_job..Cust_folder: Using NLS map MS1255-CS
( OS is win xp, sp2 )

Pls assit.

Thank you all

chulett · Post by **chulett** » Fri Nov 27, 2009 9:52 am

Nothing there seems like an error. Are any of those fatal? Warnings?

And can you give some specifics on how you are 'reading' the xml file? You've got a Folder feeding the XML Input stage but how is it configured? For example - are you just passing in just the filename and using the URL/Filepath option in the XML Input stage or is the Folder configured to pass the entire file?

Selva_dwh · Post by **Selva_dwh** » Fri Nov 27, 2009 10:18 am

When I compile I get the below errors

Event : info
Serer_xlm_read_to_DB_job: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH

Event : info
Serer_xlm_read_to_DB_job..Cust_folder: DSD_DIROpen set &Folder& to "d:\outxml.xml"

Event : info
Serer_xlm_read_to_DB_job..Cust_folder: Using NLS map MS1255-CS

Event : Warning
Serer_xlm_read_to_DB_job..Cust_folder.DSLink6: DSD.UVOpen Unable to open folder d:\outxml.xml.

Event: Fatal
Serer_xlm_read_to_DB_job..XML_Input_0: |Serer_xlm_read_to_DB_job..Cust_folder.DSLink6: DSD.UVOpen Unable to open folder d:\outxml.xml.|

In the server job I have placed a folder , and given the file path name,and have added
FileName
Record
( imported from table definitions ) .

and added intput stage , only 3 cloumns( present) which are imported from table deftions to input stage .
xml source column :cust_id
Column content : XML document.

Pls let me know how to correct this and read the xml and write it to orcale table.

Thanking you

chulett · Post by **chulett** » Fri Nov 27, 2009 10:26 am

Those are runtime not compiler errors. You need to set the Folder Pathname to a directory and then the filename in the Wildcard property even if you don't need a wildcard. Looks like you've put both in the Folder Pathname.

Selva_dwh · Post by **Selva_dwh** » Fri Nov 27, 2009 11:23 am

Hi

previously

In the folder stage

stage -> properties -
Name Value
Folder PathName d:\outxml.xlm

AND IN

Outputs -> properties -
Name value
Wildcard <Blank>

Now I have added the below

stage -> properties -
Name Value
d:\

AND IN

Outputs -> properties -
Name value
Wildcard *.xlm

Still

Serer_xlm_read_to_DB_job..XML_Input_0: |Serer_xlm_read_to_DB_job..Cust_folder.DSLink6: DSD.UVOpen Unable to open folder D:\.|

Thanks

chulett · Post by **chulett** » Fri Nov 27, 2009 11:34 am

Does your user have access to that drive? Does it work if you actually put the file in a directory rather than in the root of the drive like that? I've got no way to test this, you'll need to experiment a little to see what works.

Selva_dwh · Post by **Selva_dwh** » Fri Nov 27, 2009 11:38 am

yes I have full right to read and write all.

thanks , i will keep trying

chulett · Post by **chulett** » Fri Nov 27, 2009 12:07 pm

A guess but the other thing you might try for the folder pathname is "D:", just the drive letter without the slash.

Selva_dwh · Post by **Selva_dwh** » Fri Nov 27, 2009 12:42 pm

HI -
I try that also - did not work out.

Now after few try's I got it

I created in the d:\ a dir <tester>

in the folder pathname : d:\tester

in the Wildcard : outxml.xml

It works now

It is able read a XML file and write in the txt , ( now I have to try to write in oracle table )

In the text file when I open I see the data , with some ASCI char's after each column,.

Thanks , thanks, thanks for you are support.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 27, 2009 2:14 pm

Which "ASCI chars" appear "after each column"? Can you post an example or two?

Selva_dwh · Post by **Selva_dwh** » Sat Nov 28, 2009 12:06 am

Hi

ASCII 167 is in front of data and end of data,
I not able to cut and paste it here.
when I do that ACII does not appear here .

sample data"ASCII 167 char1362605ASCI 167"

For all the column this Ascii Value is present when I open it from Notepad.

I try to filter in the sequential File stage -> general -> checked the stage use.
And in inputs ->General - I do not know what command to give to remove the Ascii value ( win xp )

Thanks

chulett · Post by **chulett** » Sat Nov 28, 2009 8:05 am

In "the data" means what, exactly? The XML you are trying to read? I find it odd that you'd have extended ASCII characters in an XML file.

Selva_dwh · Post by **Selva_dwh** » Sat Nov 28, 2009 8:36 am

sorry I have not mentioned that :

After reading the XML file , I moving the xml data to a sequential file stage

when I open the final output file , ie., the txt file , I see those ascii char
in front of each column and end of the column .

The above is a server job.

The Same when I do in a parallel job , I am to read but nothing is writing in sequential file stage. not runtime error also.

I am looking for some doc's on xml input , xml output and xml transformer which could be used in server and parallel jobs.

Pls share if any

chulett · Post by **chulett** » Sat Nov 28, 2009 10:37 am

Well, there's always the manuals and the 'Help' button inside each stage. And this Best Practices Document which is chock full o' useful nuggets.

ray.wurlod · Post by **ray.wurlod** » Sat Nov 28, 2009 3:51 pm

Any NLS map name ending in "-CS" is intended only for communication between DataStage client and DataStage server.

Try changing the map name to simply "MS1252".