Page 1 of 1

Can not delete category from designer

Posted: Tue Sep 25, 2012 1:40 pm
by kurics40
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

Posted: Tue Sep 25, 2012 4:37 pm
by ray.wurlod
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.

Posted: Tue Sep 25, 2012 11:36 pm
by kurics40
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

Posted: Wed Sep 26, 2012 6:49 am
by chulett
Sounds to me like your repositories are out of sync, in your shoes I would contact my official support provider for help.

Posted: Thu Oct 11, 2012 2:24 pm
by kurics40
Yes. You are right. I received the SyncProject Tool. I will inform you how it works.

Posted: Sat Oct 13, 2012 5:27 am
by kurics40
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