Page 1 of 1

Parameter Set changes not updating the Jobs

Posted: Thu Jun 13, 2013 10:34 am
by MrBlack
Has anyone else notice that if you have a job(s) that use a parameter set, that if a change is made in the parameter set, it is not reflected in the job?

The situation I'm running into is I delete a variable from my parameter set but my job still thinks the variable is there and asks for it when I run my job and of course fails. I've tried:
  • recompiling
    removing/adding the parameter set to the job
    closing my designer and reopening
    making a copy of the job
    and a combinations of all of the above
No matter what I do, my job thinks the variable is still there. I can see the variable in the job control source code. So what I've had to do is export the job, use notepad to remove the bad code and import the job.

Posted: Thu Jun 13, 2013 11:14 am
by chulett
What version of DataStage?

Posted: Thu Jun 13, 2013 11:31 am
by MrBlack
Datastage 8.1 unfortunately

We're working on upgrading to 9.1 but that's still a couple of months away.

Posted: Thu Jun 13, 2013 12:34 pm
by chulett
Others would have to confirm but from what I recall that was an issue in "older" 8.x versions that was subsequently corrected.

Posted: Thu Jun 13, 2013 3:01 pm
by asorrell
That is definitely fixed in 8.7. Another way to fix it is to save the job without the parameter set, exit the client, come back in and load the parameter set back into the job. Its a real pain on the early releases of 8.