Unable to delete project in adminsitrator

ketfos · Post by **ketfos** » Fri May 06, 2011 6:23 pm

Hi,

My Unix project directory has been deleted.

i am trying to delete the project name using the administrator .

I am getting an error message

Direcotry you are connecting to either is not a UV account or does not exists (39125)

How do I delete this project in datastage?

greggknight · Post by **greggknight** » Fri May 06, 2011 6:32 pm

Well I assume you do project backups on a frequent basis ??
Restore the project.

Then if you really don't want it delete it the right way.

ketfos · Post by **ketfos** » Fri May 06, 2011 6:54 pm

Hi,

I want to recreate the project with the same name as the back up file is corrupted.

How do i do as administrator says that project already exists.
Thanks
Ketfos

chulett · Post by **chulett** » Fri May 06, 2011 9:50 pm

You might start by searching the forums here for UVFIXFILE or fixtool.

ray.wurlod · Post by **ray.wurlod** » Sat May 07, 2011 6:09 pm

Those utilities probably won't solve this one. Your first task is to determine why the Administrator is reporting that the project still exists, and to tell us who deleted it incompletely and using which method.

If there is an entry for the project in the UV.ACCOUNT table, this entry can be deleted.
If there is an entry for the project in the UV_SCHEMA table, then the VERIFY.SQL tool needs to be used to correct this. (You will not be able to use DELETE with this table. It's protected.)

chulett · Post by **chulett** » Sat May 07, 2011 6:44 pm

Ah... you so right. That was the one that I was trying to remember but my searching only turned up the other two.

jwiles · Post by **jwiles** » Mon May 09, 2011 1:13 pm

From the description, it sounds like there will also be data left in XMETA as well, which is probably where Administrator is now getting it's list of projects from. Those will need to be removed as well as any lingering data in UV.

The OP should contact their official support provider for the correct instructions for cleaning this up. For 8.0 and 8.1 it's a multi-step process. I think it's improved for 8.5, but don't know the specifics.

Regards,