Page 1 of 1
Cannot Delete a File
Posted: Mon Oct 02, 2006 11:27 am
by 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?
Posted: Mon Oct 02, 2006 3:02 pm
by 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
This will check for orphaned jobs and hashed files associated with them.
If that doesn't work, post back here.
Posted: Thu Oct 12, 2006 10:56 am
by 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.
Posted: Thu Oct 12, 2006 2:35 pm
by 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.