Migraton ISSUE

devilsmentor · Post by **devilsmentor** » Fri Apr 06, 2007 9:56 am

hi all,
i am having a strange problem when moving my job from one environment to other. The password is set as global variable #$P_Tgt_Password#. when i move the job, and try to view data i get an error message "invalid username/password". If i delete the variable from job parameters and insert it again by choosing "Add environment Varable", it runs fine again. I dont have to edit the variable, all i have to do is delete and re-insert it which is quite not good. Can anyone help on this plz. Thanks.

DSguru2B · Post by **DSguru2B** » Fri Apr 06, 2007 9:59 am

Thats odd. What version of DataStage are you using? Sounds like a bug.

devilsmentor · Post by **devilsmentor** » Fri Apr 06, 2007 10:03 am

DSguru2B wrote:Thats odd. What version of DataStage are you using? Sounds like a bug.

7.5.1

ray.wurlod · Post by **ray.wurlod** » Fri Apr 06, 2007 10:14 am

Is there a "$" or a "#" in the password itself?

devilsmentor · Post by **devilsmentor** » Fri Apr 06, 2007 10:22 am

ray.wurlod wrote:Is there a "$" or a "#" in the password itself? ...

no the password has no special characters. its a string.

ds_developer · Post by **ds_developer** » Fri Apr 06, 2007 12:37 pm

I just want to clarify one thing - View Data does not use user defined environment variables well. You have to type in the values when it prompts, you can't just use $PROJ_DEF. Later in the posting you said you ran the job - that will use the environment variable's value.

Just making sure we are comparing apples to apples.

John

DSguru2B · Post by **DSguru2B** » Fri Apr 06, 2007 12:55 pm

ds_developer wrote:View Data does not use user defined environment variables well. You have to type in the values when it prompts, you can't just use $PROJ_DEF.

Thats why I asked for DataStage version. They fixed that in 7.5 and the OP is on 7.5.1, so that should not be an issue.

devilsmentor · Post by **devilsmentor** » Fri Apr 06, 2007 2:11 pm

DSguru2B wrote:
ds_developer wrote:View Data does not use user defined environment variables well. You have to type in the values when it prompts, you can't just use $PROJ_DEF.
Thats why I asked for DataStage version. They fixed that in 7.5 and the OP is on 7.5.1, so that should not be an issue.

hey brian (if that's ur name

),
do you mean to say, Ascential has this bug in their previous releases. If so i can post this issue to them. And i would love to do that.

And John,
My variables dont prompt me for inputs as i use $PROJDEF. else how can the jobs run on their own, they will be prompting me for inputs everytime i run. And as per comparing apples to apples, both the times i view data...to make it less of effort.

Also, i would like to know if any of you guys faced or heard of this issue before.
And thanks to all for the responses, please keep them comin ... thanks

ds_developer · Post by **ds_developer** » Fri Apr 06, 2007 2:12 pm

I don't know what was fixed in 7.5, but I'm on 7.5.2 and View Data using $PROJDEF still does not get the value from the project.

John

DSguru2B · Post by **DSguru2B** » Fri Apr 06, 2007 3:27 pm

ds_developer wrote:I don't know what was fixed in 7.5, but I'm on 7.5.2 and View Data using $PROJDEF still does not get the value from the project.

I should not have said fixed. Its more like an enhancement. Check gateley's reply in thispost for confirmation. View data does work in 7.5 and higher versions with $PROJDEF.

As per the OP's experience with this behaviour, it might be a bug. Give support a call and see what they have to say.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 07, 2007 4:07 am

I can't check at the moment. My experience is that $PROJDEF works in 7.5.1A for string parameters, but I wonder is this also the case for encrypted parameters?