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" (910819)

RESOLUTION

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

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

4. Build the OLAP cube.