Environmental variable issue

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
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Environmental variable issue

Post by siva4joy »

hi,
i am using a job parameter in the job and i am running the job through a sequence using a environmental variables.
but i am getting the following error and job gets aborted.

oraBadaSample: Bad dboption list. Failed on Expected value for property "password"
main_program: Creation of step finished with status = FAILED.


can anybody tell me where is the error.
highly appreciate your help in this.
dnsjain
Charter Member
Charter Member
Posts: 34
Joined: Thu May 08, 2003 2:12 pm

Post by dnsjain »

Siva,

You need to make sure that you are pssing the parameter values from the sequence job to the job getting called. The error you are getting show that parameter values are not passed to the job.

Open sequence job and set parameter values to the calling job.

Dinesh
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Post by siva4joy »

thanks for your reply.
i am getting the error because of passing the environmental variable in the sequence for the password and only for password i am getting the error. if i am leaving the password value in the sequence the job is running fine.for remaining all values i am using the $PROJDEF as the values in the sequence.
because of password is in encrypted form we can't give hte value to $PROJDEF.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

You can give $PROJDEF for encrypted variables also.
Just key in $PROJDEF in the encrypted mode for your password variable in the job parameter grid.
siva4joy wrote:for remaining all values i am using the $PROJDEF as the values in the sequence.
because of password is in encrypted form we can't give hte value to $PROJDEF.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply