Cannot find record JOBPARAMINSTS in executable job file

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
anil411
Premium Member
Premium Member
Posts: 53
Joined: Thu Aug 11, 2005 8:34 am

Cannot find record JOBPARAMINSTS in executable job file

Post by anil411 »

Hi All ,

when I am trying to schedule ANY job from datastage director, I am getting the below error.

"Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG8762 "

I tried to recompile the job but still the same problem persists. This problem is only in one project. In other projects on the same server, I am able to schedule the jobs.

I have tried below options but still having problem
First Found JobName for 8762 (it is a Sequencer job) and then did
1. UVFIXFILE RT_CONFIG8762
-->
Beginning TRACE of RT_CONFIG8762
TRACE of RT_CONFIG8762 completed.

Scanning overflow buffers.
Scan complete.

1 groups(s) processed.
1 group buffer(s) processed.
1 record(s) processed.
Number of data bytes = 526.
<--

2.Added the new parameter to the job and recompiled the job
3.did copy of the job and deleted the origenal job and copyied copyof.. job to origenal job

Now getting below error

"Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG9232 "

getting error for another job.

Can any one suggest any possible solution?

Thnx in advance
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

1) Make sure you have a backup of the existing project
2) Run DS.CHECKER on the project from the Admin client

That usually corrects problems with internal structures. - If it reports an error, or doesn't fix the problem, come back and post...
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
anil411
Premium Member
Premium Member
Posts: 53
Joined: Thu Aug 11, 2005 8:34 am

Post by anil411 »

--> Make sure you have a backup of the existing project
What do you mean,is there any chance of losing jobs?.

--> Run DS.CHECKER on the project from the Admin client

Could you please let me know what DS.CHECKER will do.
1.Is it going to delete/clear any jobs/logs
2.what kind/type of error messgae will come

Thanks for your Help.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DS.CHECKER does not touch job logs for jobs that exist in the project. It must be run with exclusive access to the project, and cleans up any "orphan" files/tables left over from incomplete deletion of jobs.

DSPARAMINSTS is a record in a hashed file in which the parameter values entered when scheduling a job are stored. If the job is already scheduled, try explicitly removing it from the schedule (unscheduling it) then re-scheduling it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
anil411
Premium Member
Premium Member
Posts: 53
Joined: Thu Aug 11, 2005 8:34 am

Post by anil411 »

Thanks Ray. It Worked.
joycerecacho
Participant
Posts: 298
Joined: Tue Aug 26, 2008 12:17 pm

Re: Cannot find record JOBPARAMINSTS in executable job file

Post by joycerecacho »

Hey my friend,

I did a copy of my job and rescheduled it.
it worked.

Best Regards,
Joyce A. Recacho
São Paulo/SP
Brazil
Post Reply