Project Deletion Unsuccessful

senthilt1 · Post by **senthilt1** » Fri Sep 18, 2009 12:42 pm

Hi All,

When i was creating a new project in Administrator, due to some issue in unix server, my DS adminstrator got closed abruptly. So the project has not created completely.

When i tried logging again to the adminstrator it throws error message related to the project which i was creating. So i deleted this project from the project directory in the unix server manually. Even then it gives the error message like "Unable to connect to the Server and then that project name".

From the other post i got the info like to delete the entry from UV.account file and then from the Xmeta repository. I am not clear about how to do this steps.

Can someone help me to resolved this issue???

Many Thanks,

Senthil Kumar P

senthilt1 · Post by **senthilt1** » Fri Sep 18, 2009 9:44 pm

Hi all,

Any update please...Thanks,

Senthil P

chulett · Post by **chulett** » Fri Sep 18, 2009 10:00 pm

If anyone has anything to contribute, they will. Patience. If you don't want to wait, contact your official support provider, something I think you'll need to do regardless now that you've manually deleted part of the project.

Can you post a link to this "other post" you found?

ray.wurlod · Post by **ray.wurlod** » Sun Sep 20, 2009 4:49 pm

Particularly on weekends you need patience. Some of us actually have a life.

Deleting a directory is not the same as deleting a project. There are entries in the repository and entries in the DataStage "system tables" UV_SCHEMA and UV.ACCOUNT that describe the existence and location of each project. You would need to clean these up as well.

Search for VERIFY.SQL to learn about the command to manage the UV_SCHEMA table. UV.ACCOUNT is a straightforward DELETE command. I don't yet have enough information about the XMETA repository to advise on what you need to do there.

ArndW · Post by **ArndW** » Mon Sep 21, 2009 1:28 am

By using a UNIX level delete of the directory you have corrupted your project and no longer can delete it normally.

Try creating a new dummy project, then copying that directory contents to your old project directory and re-trying your delete.

Ahh, I just saw that you have version 8, that method may no longer work.

senthilt1 · Post by **senthilt1** » Tue Sep 22, 2009 5:10 am

Hi All,

Thanks for your replies....

I tried using the Delete command,
DELETE UV.ACCOUNT 'DWTest'
DELETE FROM UV.ACCOUNT WHERE @ID = 'DWTest';

But i couldnt get the tables UV.ACCOUNT in the Xmeta database. also there is no schema called UV.

Please let me know from where i can query this.

Find the list of available schemas below in XMETA database.

TABSCHEMA
-----------
SYSCAT
SYSIBM
SYSIBMADM
SYSSTAT
SYSTOOLS
TSAINST2
XMETA

chulett · Post by **chulett** » Tue Sep 22, 2009 5:23 am

chulett wrote:contact your official support provider, something I think you'll need to do regardless now that you've manually deleted

even more of the project.

eostic · Post by **eostic** » Tue Sep 22, 2009 5:30 am

It would be practical to determine if (a) you can still create a "new" project and (b) if you can get into it and use this new project. ...and then forget about the old project that won't delete. Ignore it. Spend your time on building the new jobs that you are working on!

Ernie

chulett · Post by **chulett** » Tue Sep 22, 2009 5:42 am

But... but... they'd never be able to use "DWTest" as a project name ever again!

[/kidding]

senthilt1 · Post by **senthilt1** » Tue Sep 22, 2009 6:14 am

Hi Ernie,

The problem here is i am unable to login to the Adminstrator because of this issue. So i am not able to create new project.

Thanks for all your help...

Will get in touch with Support provider and update you...

Senthil Kumar P

ray.wurlod · Post by **ray.wurlod** » Tue Sep 22, 2009 2:55 pm

UV.ACCOUNT is not in the XMETA database at all. It is a "system table" for the DataStage server engine itself.

senthilt1 · Post by **senthilt1** » Wed Sep 23, 2009 12:53 am

Hi Ray,

Thanks for the info....

So where should we use and execute these queries??
DELETE UV.ACCOUNT 'Project'
DELETE FROM UV.ACCOUNT WHERE @ID = 'Project';

Is it in DS Admin Command prompt???

Regards,
senthil Kumar P

ArndW · Post by **ArndW** » Wed Sep 23, 2009 1:09 am

Those commands are used in the command tool or from a dssh shell; but they won't necessarily solve your problem. Deleting the UV.ACCOUNT entry does not remove the schema and does not address any entries in xmeta.

eostic · Post by **eostic** » Wed Sep 23, 2009 12:23 pm

Ok.. missed that you weren't able to get into the Administrator. I would have hoped that it would just choke on "that" project when trying to put it into the list. Keep us posted.

Ernie

senthilt1 · Post by **senthilt1** » Sun Sep 27, 2009 9:41 am

Hi All,

Thanks a lot for all your inputs.

Finally this issue is resolved by Support Provider(IBM). We have to clean the project entries in UV file and then the Xmeta. We can clean it in UV but to remove the entries from Xmeta its look complex only they can solve this with the scripts.

This is for your info.

Senthil P