Cannot Delete a File

[kld05]

I'm trying to clean up my project and am getting an error when I try to delete one job: "Cannot open exectuable job file RT_CONFIG118"

Does anyone know how to get around this?

[ray.wurlod]

What is job number 118?

Code: Select all

SELECT NAME, CATEGORY FROM DS_JOBS WHERE JOBNO = '118';

Have you made an earlier attempt to delete this job?
From the Administrator client or from a telnet session execute the command

Code: Select all

DS.CHECKER

This will check for orphaned jobs and hashed files associated with them.

If that doesn't work, post back here.

[kld05]

Ray.

There was an attempt to delete these jobs which no doubt caused the issue. I am able to run the selects and retreive the object names but DS.CHECKER is not flagging the job as an orphan. I'm still unable to delete the job for some reason.

[ray.wurlod]

Can you see/open the particular job in Designer, Manager, Director?

If so, you should be able to delete it (once closed) from the GUI.

Otherwise, you will need to delete references to it from DS_JOBS and DS_JOBOBJECTS using SQL, and to remove the repository tables using recursive rm commands.
Make sure that you have two good backups of the project before proceeding!

Code: Select all

DELETE FROM DS_JOBOBJECTS WHERE CLASS = '2' AND OBJIDNO = '118';

DELETE FROM DS_JOBS WHERE JOBNO = '118';

SH -c "rm -rf RT_*118 DS_*118"

I'm assuming here that you don't have job number 1118 yet; if you do you will need a somewhat more specific set of rm commands.