Look in the log file for each run type (alone and from sequence) and see what's being passed as this parameter. Compare the values. Please also advise your exact version of DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:Look in the log file for each run type (alone and from sequence) and see what's being passed as this parameter. Compare the values. Please also advise your exact version of DataStage.
Hi Ray,
From log file nothing can be found as it is showing the password in cipher form. For Sequence it is shown as
In the job parameters of your sequence,go to the password parameter and set its value to
$PROJDEF .
Type this manually in the value field for password environment variable.You will see only ** as the value is encrypted.
It seems that the password environment variable is imported,but it's value is set to your dev password.
If the password field is imported in dev,the dev password is assigned to the password env variable.When the code is moved to the other region,the password does not change.It maintains the older value.Hence,the value of password field should always be set to $PROJDEF.
Thank you. I find this thread when I was searching the similar issue. By this I could resolve the issue(DS 8.0.1). A ton of thanks dude.
My personal email : ramtorule@gmail.com
nikhilanshuman wrote:In the job parameters of your sequence,go to the password parameter and set its value to
$PROJDEF .
Type this manually in the value field for password environment variable.You will see only ** as the value is encrypted .
It seems that the password environment variable is imported,but it's value is set to your dev password.
If the password field is imported in dev,the dev password is assigned to the password env variable.When the code is moved to the other region,the password does not change.It maintains the older value.Hence,the value of password field should always be set to $PROJDEF.
Thank you. I find this thread when I was searching the similar issue. By this I could resolve the issue(DS 8.0.1). A ton of thanks dude.
My personal email : ramtorule@gmail.com
nikhilanshuman wrote:In the job parameters of your sequence,go to the password parameter and set its value to
$PROJDEF .
Type this manually in the value field for password environment variable.You will see only ** as the value is encrypted .
It seems that the password environment variable is imported,but it's value is set to your dev password.
If the password field is imported in dev,the dev password is assigned to the password env variable.When the code is moved to the other region,the password does not change.It maintains the older value.Hence,the value of password field should always be set to $PROJDEF.