Microsoft KB Archive/910819

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

Article ID: 910819

Article Last Modified on 12/9/2005

-

APPLIES TO


 * Microsoft Office Project Server 2003

-



SYMPTOMS
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:

The cube scheduled to be built on  at   failed. (457) This key is already associated with an element of this collection.



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



RESOLUTION
To resolve this issue, follow these steps:  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

 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:  Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer. Log on to SQL Server. Click the Project Server 2003 database. In the code window, type the following command:

truncate table MSP_VIEW_PROJ_ASSN_CF

</ol> </li> 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

</li> Build the OLAP cube.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
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:

835477 Some projects are not listed on the Project Center page of Microsoft Project Web Access after you upgrade from Microsoft Project Server 2002 to Project Server 2003

Additional query words: projectserver2003 projectserver2k3 prjsvr2003 prjsvr2k3

Keywords: kberrmsg kbtshoot kbprb KB910819

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.