Duplicate Entry in msp_view_proj_projects_ent Table

[Kishore]

Hello All -- Happy New Year!
We use Project Server 2003, and I found a duplicate entry for a Proj_ID in
msp_view_proj_project_ent table. Where as there is only one row for that
specific project in MSP_Projects table. Under what conditions will this table
have two entries for one project.

Here are the records:

MSP_PROJECTS Table
--------------------------
Proj_ID | Proj_Name
----------------------------------------------------------
2676 | <>\ABC_Support_Plan_08.Published


MSP_VIEW_PROJ_PROJECTS_ENT Table
-----------------------------------------------
WPROJ_ID | Ent_ProjectUniqueID
---------------------------------------------
3765 | 2676
3767 | 2676

What is the cause for these 2 entries and How to remove these duplicate
entries?

Thank you for your help in advance.

 

[Chak]

Hello All -- Happy New Year!
We use Project Server 2003, and I found a duplicate entry for a Proj_ID in
msp_view_proj_project_ent table. Where as there is only one row for that
specific project in MSP_Projects table. Under what conditions will this table
have two entries for one project.

Here are the records:

MSP_PROJECTS Table
--------------------------
Proj_ID      |      Proj_Name
----------------------------------------------------------
2676          |     <>\ABC_Support_Plan_08.Published

MSP_VIEW_PROJ_PROJECTS_ENT Table
-----------------------------------------------
WPROJ_ID    |        Ent_ProjectUniqueID
---------------------------------------------
3765            |        2676
3767            |        2676

What is the cause for these 2 entries and How to remove these duplicate
entries?

Thank you for your help in advance.

Kishore,

Run the SQL query on database to find out the project names for
WPROJ_ID 3765, 3767
May be you will get the same name for both IDs.

Anyhow, one of the possible reason of duplication is, If you are
trying to delete the project from PWA and you got timed out (error
occured message), the deletion process will be incomplte. Other reason
might be during creation of the project.

Recently, Microsoft relased the Duplicate Project Deletion
application.

Download DupeProj.exe utlity and install on your server.

Download Link: http://go.microsoft.com/fwlink/?linkid=20893

Thanks
Chak