Environment Variable Error

ririr · Post by **ririr** » Wed May 24, 2006 10:33 am

I have Environment Variables created in a project. When reference in a job I have the default value set to $PROJDEF under job parameters. The "View Data" in the stage is throwing "TNS ERROR".

But when I take off $PROJDEF as default value and reload the environment variable it tags the database name to the default value. And the "View Data" in the stage retreives the data back.

I do not think it is a problem with the TNS names. The TNS error only appears when I use $PROJDEF as default value.

Please advise.

DSguru2B · Post by **DSguru2B** » Wed May 24, 2006 10:39 am

with $PROJDEF you cannot view the data. It only loads it during run time. Thats why you are facing this error. I believe in the newer version (7.5.2) they have changed this. I guess you have an earlier version thats why its happenening.

ririr · Post by **ririr** » Wed May 24, 2006 10:49 am

You are right. Is there a ptach available that you know to fix this issue?

DSguru2B · Post by **DSguru2B** » Wed May 24, 2006 11:04 am

Not that i know of. Maybe there is. Contact IBM for that.
IMHO, its not an issue. If you want to view the data, just go to the directors log, in the first entry of the job start where it loads all the environment variables, just keep a copy of that somewhere and keep pasting appropriate values to view data.

kris007 · Post by **kris007** » Wed May 24, 2006 11:23 am

As per Craig

There is a patch available - it's called 7.5.1A... or, very shortly, 7.5.2.

DSguru2B · Post by **DSguru2B** » Wed May 24, 2006 11:26 am

Yup. Craig's sense of humour always freshens my day.

gateleys · Post by **gateleys** » Wed May 24, 2006 12:21 pm

DSguru2B wrote:I believe in the newer version (7.5.2) they have changed this.

7.5.1A has the problem fixed.

gateleys

DSguru2B · Post by **DSguru2B** » Wed May 24, 2006 1:44 pm

which i think is known as 7.5.2, Right? Or am i day dreaming