cannot open executable job file RT_CONFIG0

coface · Post by **coface** » Thu May 29, 2008 5:10 am

Hello,
when starting the DataStage Director a message box with the following error pops up:
cannot open executable job file RT_CONFIG0

This error occured suddenly, no changes to DataStage or the OS have been made. But I've noticed that the /tmp directory didn't have any space left (filled to 100%). Cleaning up the directory didn't help at all.
I'm astonished about the 0 in the error message (RT_CONFIG0). There is no directory RT_CONFIG0 in the filesystem. When viewing the details of the job the parameter "Wave#" has the value 0 (which seems strange to me).
Does anybody know how to solve this problem?

Any help will be appreciated
Rgds
Jan Hauschildt

ArndW · Post by **ArndW** » Thu May 29, 2008 5:15 am

Can you try to DS.REINDEX, it might be a defect index.

coface · Post by **coface** » Thu May 29, 2008 5:26 am

ArndW wrote:Can you try to DS.REINDEX, it might be a defect index.

Hello,
I have already tried that before (sorry for not mentioning it) - but that didn't help at all.

Rgds
Jan Hauschildt

coface · Post by **coface** » Thu May 29, 2008 5:28 am

ArndW wrote:Can you try to DS.REINDEX, it might be a defect index.

Hello,
I have already tried that before (sorry for not mentioning it) - but that didn't help at all.

Rgds
Jan Hauschildt

ArndW · Post by **ArndW** » Thu May 29, 2008 5:45 am

That means that one or more of your DataStage hashed files might be corrupt, most likely caused by the disk full condition. If the project directory didn't fill up then I would try a quick multiple job force compile of the whole project from the designer - this might (low probability) clean things up, but is easy to do.

ray.wurlod · Post by **ray.wurlod** » Thu May 29, 2008 5:48 am

My punt would be DS_JOBS, because there should never be a job number 0.

ArndW · Post by **ArndW** » Thu May 29, 2008 5:57 am

I think so as well, and if the SELECT for the multiple job compile fails then it would point there as well.

coface · Post by **coface** » Thu May 29, 2008 6:46 am

ArndW wrote:I think so as well, and if the SELECT for the multiple job compile fails then it would point there as well.

the force compile didn't help...

@ray:
what do you mean by DS_JOB?

Rgds
Jan H.

ArndW · Post by **ArndW** » Thu May 29, 2008 6:54 am

Did the multiple job in fact go and compile your project's jobs?

From the Administrator or from TCL, execute the command "COUNT DS_JOBS". Do you get a record count or an error message?

coface · Post by **coface** » Thu May 29, 2008 7:00 am

ArndW wrote:Did the multiple job in fact go and compile your project's jobs?

From the Administrator or from TCL, execute the command "COUNT DS_JOBS". Do you get a record count or an error message?

the multiple compile has compiled all jobs - just the one which causes the error not.
Executing the command COUNT DS_JOBS returns "198 records counted".

Might it be helpful to delete all jobs and to redeploy them?

I'm still wondering where the job number 0 comes from...

Rgds
Jan H.

ArndW · Post by **ArndW** » Thu May 29, 2008 8:24 am

Can you save the job that isn't working under another name, delete the original, rename & recompile the copy?

ray.wurlod · Post by **ray.wurlod** » Thu May 29, 2008 3:32 pm

Is there any warning of the form "non numeric where numeric required, zero used" in the job log or anywhere else? (I'm puzzling over the zero in the RT_CONFIG0 name still.)

coface · Post by **coface** » Fri May 30, 2008 2:05 am

ArndW wrote:Can you save the job that isn't working under another name, delete the original, rename & recompile the copy?

I have exported all jobs and deleted them. After importing all jobs again the error still occurs.

Rgds
Jan H.

coface · Post by **coface** » Fri May 30, 2008 2:06 am

ray.wurlod wrote:Is there any warning of the form "non numeric where numeric required, zero used" in the job log or anywhere else? (I'm puzzling over the zero in the RT_CONFIG0 name still.)

No, no entries like "non numeric" found.

Rgds
Jan H.

ArndW · Post by **ArndW** » Fri May 30, 2008 2:20 am

At the TCL prompt or from the administrator, enter:

UVFIXFILE DS_JOBS
UVFIXFILE DS_JOBOBJECTS

and please post the results.