Tuesday, November 10, 2009

Project Connections lost IS 8.0.1 (Unable to Delete Project)

Error Message - Project Connections lost IS 8.0.1 (Unable to Delete Project)

Reason - The project was in deleting progress when the remote server connections was down. This locked up the project..... The client went in and deleted the file path that the project resided.

Now the Administrator shows a project that doesn't exist. Is there a Universe command that will delete that entry in the project ?

Resolution - Use the command as follows using dsadm@DSHOME/bin/uvsh

DELETE UV.ACCOUNT project_name (to delete a project manually)

If you try next to recreate the original project name and get an error:
DSR.ADMIN: A schema called '...' already exists. This must be dropped before the project can be created.

Then:

LIST UV_SCHEMA (to see if the project schema is listed)

VERIFY.SQL SCHEMA tarp2p FIX

LIST UV_SCHEMA (verify if the project schema is gone - it should be gone)

Other workaround:

The project shows in the DS Administrator because it still exists in the new repository, not DSEngine. If you select the project in DS Admin, you will get an error message and Admin will exit.

There are Scases & Ecases requesting a utility to fix the repository when this occurs, and we are currently investigating productization of an engineering tool to check the repository's integrity.

It is possible to remove the top-level project reference easily from XMETA, by deleting one row from the relevant table, but this leaves all the project objects in the databases. There is also an SQL script that will delete all project objects for any named project, which will clear up the database for you. This is platform-specific so please raise a support case for your current issues.

No comments:

Post a Comment