Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 910819 - Last Review: September 18, 2011 - Revision: 3.0
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:
The cube scheduled to be built on date at time failed. (457) This key is already associated with an element of this collection.
This issue may occur when there are duplicate project plans in the project database.
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: - 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
- 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: - 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:
835477Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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
APPLIES TO
- Microsoft Office Project Server 2003
| kberrmsg kbtshoot kbprb KB910819 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate