Page 1 of 1

main_program: No collation sequence found for en_US, using d

Posted: Wed Aug 24, 2005 1:51 pm
by vinaymanchinila
Hi,
I am able to runt he job but I am getting two warnings, I am not sure what can be done .

1) main_program: No collation sequence found for en_US, using default locale root

2) main_program: Warning: the value of the PWD environment variable (/opt/etl/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/opt/etl/Ascential/DataStage/Projects/BR_DEVL). The current working directory will be used, but if your ORCHESTRATE job does not start up correctly, you should set your PWD environment variable to a value that will work on all nodes of your system.

Appreciate your help.
Thanks,

Re: main_program: No collation sequence found for en_US, usi

Posted: Tue Sep 27, 2005 9:39 pm
by mabramson
Hello My ETL Friend,

This looks like a Unix permission error. The job may run, however, it may not be able to write to the Unix server. You may want to verify the permissions of the person who created the job and the one running the jobs.

Posted: Wed Sep 28, 2005 9:42 am
by kumar_s
Hi,
The first issue is due to NLS problem, it might be due to bad installaion or due to improper permission granted to certain folder.
I guess you may not get that warning when you logon as dsadm.

regards
kumar

Posted: Wed Sep 28, 2005 4:32 pm
by ray.wurlod
Also try setting PWD=.

Posted: Thu Sep 29, 2005 7:50 am
by Eric
the PWD error may well be because you are starting the DataStage engine from a ksh. ALso what locale settings have you used in the DSENV file?