Error with Enviornment variables

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mdtauseefhussain
Participant
Posts: 38
Joined: Mon Feb 27, 2006 10:34 pm
Location: Chennai
Contact:

Error with Enviornment variables

Post by mdtauseefhussain »

HI All

We are using 7.5 version of Datastage Server Edition.

In datastage Administrator we set the Enviornment variables as

Name Type Prompt Value
SAP_DATABASE_PAR String SAP Database AAA
SAP_USERNAME_PAR String SAP Username BBB
SAP_PASSWORD_PAR Encrypted SAP Password ****

and we used these variables in the job and it worked fine with default values and with setting $PROJDEF as well

Then we changed the name of these enviornment variables
from
SAP_DATABASE_PAR
SAP_PASSWORD_PAR
SAP_USERNAME_PAR
to
SAP_Database_Par
SAP_Password_Par
SAP_Username_Par

If i use these new variable in Job properties with default values the job is working fine.but if i set it to $PROJDEF the job is getting aborted ,when i check in the Datastage director i see blank getting passed to these Valeus instead of default values .

Please help me to resolve this.

Thanks in Advace

Mohammed Tausif
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Did you change the values in the Administrator tool or did you edit the files from UNIX? The first line in the log of a job run will show the ENV values - which parameters are declared there, the old names or the new ones?
mdtauseefhussain
Participant
Posts: 38
Joined: Mon Feb 27, 2006 10:34 pm
Location: Chennai
Contact:

Post by mdtauseefhussain »

I changed the values in Datastage Administrator
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
mdtauseefhussain
Participant
Posts: 38
Joined: Mon Feb 27, 2006 10:34 pm
Location: Chennai
Contact:

Post by mdtauseefhussain »

If you see the Director log

SAP_Database_Par=
SAP_Password_Par=LL:@1;V@N93L0O4I<;JM3KIFB<>MM0
SAP_Username_Par=

You cans see the balnk instead of default vaues
The Error " User Id is a required stage property".
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
Post Reply