DSXchange

Hi to all,

Hi this is satya. When i am running the sever job its finished.after i will run the sequence job that server job is aborted.

The error is coming like this:
Unknown: DSCGetStrStageProp value (??) of property (PASSWORD) contains unmappable characters (MS1252)
ORA-01017: invalid username/password; logon denied

When i am giving the username and password as hard coded its finished.

Please help me in this problem.

"invalid username/password; logon denied "
Are giving the password as Encrypted? The parameter passed in the Database job should be covered with #. #PasswordParameter#.
Though it will just show you *'s.

The message suggests that there are characters in your password that can not be processed by your NLS map (MS1252, US-English). Or this may be an incompatibility with Oracle's NLS mapping. Are you using the same settings for DataStage character mapping and for Oracle character mapping? What is the NLS_LANG environment variable setting?

When i am running the sever job its finished.after i will run the sequence job that server job is aborted.
Since Satya, able to run the job individually, NLS shouldnt be an issue. Should be somewhere in the method of passing the password value.