Error message when you try to build an OLAP cube in Project Server 2003: "This key is already associated with an element of this collection"

When you try to build an Online Analytical Processing (OLAP) cube in Microsoft Office Project Server 2003, the cube is not built. Additionally, you receive the following error message:

This issue may occur when there are duplicate project plans in the project database.

To resolve this issue, follow these steps:

1. Use the Delete Duplicate Projects command-line tool (DupeProj.exe) to look for and to remove duplicate projects from the Project Server 2003 database.
   
   To obtain the Delete Duplicate Projects tool, visit the following Microsoft Web site:
   http://www.microsoft.com/downloads/details.aspx?familyid=9e07a3dc-944d-48c9-b0e2-7ed296432a1d (http://www.microsoft.com/downloads/details.aspx?familyid=9e07a3dc-944d-48c9-b0e2-7ed296432a1d)
2. Truncate the data in each MSP_View table and in each MSP_Cube table to clear out any data that is inconsistent with the data in the plan or in Project Web Access.
   
   To do this, follow these steps for each MSP_View table and for each MSP_Cube table in the database:
   1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
   2. Log on to SQL Server.
   3. Click the Project Server 2003 database.
   4. In the code window, type the following command:
      truncate table MSP_VIEW_PROJ_ASSN_CF
3. Repopulate the MSP_View table by republishing the project plans. To republish the project plans without using Microsoft Office Project Professional 2003, use the View Populator Tool.
   
   To obtain the View Populator Tool, visit the following Microsoft Web site:
   http://www.microsoft.com/downloads/details.aspx?familyid=f12d82d5-3cdb-4a57-a1fd-748bf968d48b (http://www.microsoft.com/downloads/details.aspx?familyid=f12d82d5-3cdb-4a57-a1fd-748bf968d48b)
4. Build the OLAP cube.

In Microsoft Project Server 2002, duplicate projects could be published to the project database. This issue was corrected in Microsoft Project Server 2002 Service Pack 1 (SP1). If you upgrade to Project Server 2003 without installing Project Server 2002 SP1, you may still experience this problem in Project Server 2003.

For more information about how to resolve the duplicate project issue, click the following article number to view the article in the Microsoft Knowledge Base: