Issue with Encrypted Password Environment variable

[sudarsan]

Hi All,

I am facing the issue with the enviroment varaibles.

In my job, Database password variable is declared as environment
variable(encrypted).

I have declared the Encrypted password as an environment variable.

Initilally I have given one password. At that time my job is working fine.

Later on, my data base password got changed. So, I have changed the
same in environment variable.

But this new password is not affecting in job and job is getting aborted
saying that "Log in failed".

Can any one Please help me on this.

[priyadarshikunal]

type "$PROJDEF" without quotes in password's default value in the job or the top sequence from where its propogated. save it and compile.

[sudarsan]

Thanks for quick reply.

Actually,I have added the password like you said only.(In job parameters, from add environment variables, added).

[priyadarshikunal]

when you add that the value of environment variable is taken as default value in that job. When you change it in administrator it is not reflected to the job. To enable it to refer the value in administrator you select $PROJDEF in dropdown menu for other type of values but for encrypted parameters you need to specifically type $PROJDEF as password and save.

[chulett]

What 7.x version? Earlier ones required a recompile in that situation but later ones fixed that issue.

[sudarsan]

Thanks a lot....Issue solved.(As you said, I have done)

[chulett]

As who said, you done what? Switched to using $PROJDEF?

[sudarsan]

As who said, you done what? Switched to using $PROJDEF? ...

Yes Chulett. Sorry for the confusion.
Using $PROJDEF, issue is solved.