Page 2 of 2

Posted: Wed Apr 23, 2008 5:50 am
by sunayan_pal
ray.wurlod wrote:Good. So the system tables (UV_SCHEMA and UV.ACCOUNT) are intact with respect to this project.

Have you been executing these commands from the Administrator client command window? If so, at least ...
hi ray,

i guess as the repository had been deleted in this case can i delete the account from table like UV_TABLE and it will be reflecting to other UV table

will the schema need to be manually deleted or other procedure is needed to achieve the objective.

Posted: Wed Apr 23, 2008 7:08 am
by ray.wurlod
You will find that you can not delete entries from system tables. They have special protection. You need to use specific utilities (such as DDL statements) to have any impact on these tables.

But we have established already that you ought not to need to do so, since the project exists (as a directory) and the system tables appear to be intact. Or are you telling us that such is not the case?

Did you try reindexing the project?

Posted: Fri Oct 23, 2009 5:44 am
by z035011
Hi ray,

I am also facing the same problem. But while doing a re-index all from uvsh i getting errors like :

Unable to open "DICT DS_DATATYPES".
Unable to open "DICT DS_JOBS".

Unable to open "DICT DS_CONTAINERS".

Unable to open "DICT DS_JOBOBJECTS".

Unable to open "DICT DS_METADATA".


Can you suggest some solution or the whole project hav got corrupt.

The commands mentioned in this post are working fine and returning valid output

Posted: Fri Oct 23, 2009 7:06 am
by chulett
You need to check in your project and see if those "D_" files mentioned exist or not or have a permissions problem. If they are gone for some reason, they can be copied in from any other project as they are generic files.

Posted: Sat Oct 24, 2009 6:14 am
by z035011
Thanks a TON. It works

Posted: Sat Oct 24, 2009 7:00 am
by chulett
8)