Page 1 of 1

Delete Categories

Posted: Wed Aug 29, 2007 8:36 am
by shrey3a
Hi,

We are not able to delete few empty Categories, tried it from manager, designer but it gives the message "Record Category_Name in the file DS_JOBS does not exist.

Thanks,

Posted: Wed Aug 29, 2007 4:11 pm
by ray.wurlod
Try selecting View > Refresh.
Chances are that your first attempt deleted the categories successfully but the client did not auto-refresh.

Re: Delete Categories

Posted: Wed Aug 29, 2007 9:57 pm
by sachin1
Hello Ray i tried deleting category with jobs inside it as well as empty category from client machine, it deletes immediately and refreshes.

Posted: Thu Aug 30, 2007 12:02 am
by ray.wurlod
But maybe shrey3a's didn't.

Posted: Thu Aug 30, 2007 9:31 am
by shrey3a
Hi ray,

I tried it deleting, refreshing, even logging it again ...doing it from different m/c but its same.

Thanks,

Posted: Thu Aug 30, 2007 9:35 am
by shrey3a
Hi,

They are empty directories and gives message "Record Category_Name in the file DS_JOBS does not exist" even when we open up designer window pops up for each such directories and we have to click several times before opening up the job in other category. Is there a way to clean up DS_JOBS or DS_OBJECTS.

Thanks

Posted: Thu Aug 30, 2007 4:06 pm
by ArndW
The message would seem to indicate you had a job called 'Category_Name' or did you replace that text?

Posted: Thu Aug 30, 2007 8:13 pm
by ray.wurlod
It's probably not the files but the indexing.
Get exclusive access to the project and execute DS.REINDEX ALL

Posted: Thu Sep 13, 2007 1:32 pm
by shrey3a
Tried everything but its same. Can we delete categories from command line.

Thanks,


[quote="ray.wurlod"]It's probably not the files but the indexing.
Get exclusive access to the project and execute [b]DS.REINDEX ALL[/b][/quote]

Posted: Thu Sep 13, 2007 2:51 pm
by ray.wurlod
Job Categories are separate records in DS_JOBS beginning with \\\.
For example, to delete the category MyJobs\LoadHash you could execute

Code: Select all

DELETE FROM DS_JOBS WHERE NAME = '\\\MyJobs\LoadHash\';
It might be worth while to check first that the category is empty.

Code: Select all

SELECT CATEGORY, COUNT(*) AS ITEMS FROM DS_JOBS GROUP BY CATEGORY HAVING COUNT(*) = 1;