Job Parameter : Environment variable as Password

[williamswe]

Hi All,

I am using an environment variable (Oracle login password) as a job parameter.

I can run the job successfully using it, but when i tri to do "view data" i can't and get this error...


Error executing View Data command:

Bad dboption list. Failed on Expected value for property "password"

i wonder why...

thx in advance

[chulett]

That's just The Way It Works when using ENV variables like that. Job runs but you can't view data without putting a 'real' value in there.

[prabu]

Hi All,

I am using an environment variable (Oracle login password) as a job parameter.

I can run the job successfully using it, but when i tri to do "view data" i can't and get this error...


Error executing View Data command:

Bad dboption list. Failed on Expected value for property "password"

i wonder why...

thx in advance

Did you feed the correct password , when prompted by "view data".

[Krazykoolrohit]

when you do a view data. dont use variables. use hard coding when prompted for the parameter values.

[pneumalin]

This is a knon bug that has been fixed in latest patch for 7.5.1.A. Contact IBM for the patch download..

[williamswe]

Thx a lot for the info.

And any idea on how much downtime do we need to apply the patch?

[rameshrr3]

Im using 7.5.1 A and seems the bug has been fixed! i can use $PROJDEF as default value for password and view data seems to work without much complaints

[pneumalin]

That's great they put the fix in 7.5.1.A. I just heard IBM has come out with 7.5.2(Not official, but is 7.5.1.A above), this is recommended if you want this fix since this version contains a lot more fixes. Ask for your IBM representatives. As per my experience, to apply the patches doesn't take too long( Maybe an hour). Be careful on your permission setup of your project, since I noticed the upgrade process modify the permission of some project files and caused some jobs run problem during my previous patching process...