Delete Categories

[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,

[ray.wurlod]

Try selecting View > Refresh.
Chances are that your first attempt deleted the categories successfully but the client did not auto-refresh.

[sachin1]

Hello Ray i tried deleting category with jobs inside it as well as empty category from client machine, it deletes immediately and refreshes.

[ray.wurlod]

But maybe shrey3a's didn't.

[shrey3a]

Hi ray,

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

Thanks,

[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

[ArndW]

The message would seem to indicate you had a job called 'Category_Name' or did you replace that text?

[ray.wurlod]

It's probably not the files but the indexing.
Get exclusive access to the project and execute DS.REINDEX ALL

[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]

[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;