Database Clean UP

[John]

I am having an issue with a project. I was importing a project into our
environment and encountered a network issue where the import process stopped
before it completed. I tried it again and when I did, I received a message
saying that a project with the same name currently exists. However, you
can’t see the project with Project Pro or PWA. I do see the project in the
MSP_Projects table. As a matter of fact the project id is found in only the
following tables in the Project Server database:

MSP_CALENDARS
MSP_CODE_FIELDS
MPS_FLAG_FIELDS
MPS_NUMBER_FIELDS
MSP_RESOURCE_BASELINES
MSP_RESOUCES
MSP_TASK_BASELINES
MSP_TASKS
MSP_TEXT_FIELDS

I have tried using the PSCleaner tool, but it doesn’t see the project
either, i.e. the project ID and Name are not in the list of returned
projects. What is the correct way to clean the database if I can’t use
PSCleaner?

Thanks,

 

[Gary L. Chefetz [MVP]]

John:

If you can see which tables have the fractured data, why not try to delete
the records using SQL? The interface and the cleaner tool rely on the full
tree structure and can't find orphaned data as well as you can.

 

[Chak]

John,

When the import process fails in between, the whole transcation
process related to project creation in project server DB will be
incomplete. So plan may be not visible through PSCleaner. Try the
following:

1) Create the system DSN (machine data source pointing to ProjectServer
Database).

2) Launch project pro

3) File -> Open -> Open from File -> ODBC

4) select the DNS created on step 1.

You can see all the project plans from project server including ghost
plans.

5)Select the plan and click X to delete the plan

Thanks
Chak