Can not delete category from designer

kurics40 · Post by **kurics40** » Tue Sep 25, 2012 1:40 pm

Hello All,

I tried to delete all jobs including its container category. Somehow any delete or export can be easly interrupted and it gives an error message of lose the connection.

After it I can not delete category from DataStage designer. If I try to rename one of the subfolder in the main category what I tried to drop originaly it gets the name of the other subfolder.

I tried the above command from command line:

One category=Old_Jobs

Code: Select all

SELECT * FROM DS_JOBS WHERE CATEGORY LIKE ...Old_Jobs...

This doesn't return back anything.

How can I delete them?
Any suggestion is welcome.

Best regards,
Janos

ray.wurlod · Post by **ray.wurlod** » Tue Sep 25, 2012 4:37 pm

What if you close and re-open Designer? It may be that all that is needed is to refresh the client's view of the Repository.

kurics40 · Post by **kurics40** » Tue Sep 25, 2012 11:36 pm

Hi Ray,

No It doesn't solve the issue.

I restarted the all etl server and DS service.
Executed DS.CHECKER and DS.TOOLS 2 option the reindexing.

The unearaseable categories are still there.
Probably I need a UV command or xmeta SQL that I am afraid of in advance.

Can I refer on a category in DS_JOBS view?

Best regards,
Janos

chulett · Post by **chulett** » Wed Sep 26, 2012 6:49 am

Sounds to me like your repositories are out of sync, in your shoes I would contact my official support provider for help.

kurics40 · Post by **kurics40** » Thu Oct 11, 2012 2:24 pm

Yes. You are right. I received the SyncProject Tool. I will inform you how it works.

kurics40 · Post by **kurics40** » Sat Oct 13, 2012 5:27 am

Hi All,

SyncProject tool solved the issue.
It is a very smart and user friendly tool.

Feel free to use it.
It is resolved.

Br,
Janos