Error building OLAP cube...

[Jan Davidek]

Hallo all,

i have a quite specific problem... in my Project Enterprise Environment,
everything worked fine till i made some changes in the database... i know i
should not do that - dont tell me

My problem is, that i receive an error when building the OLAP cube:

"The cube scheduled to be built on 8.9.2003 at 15:09 failed.

(457) This key is already associated with an element of this collection"

I suppose this has something to do with ghost projects that appeared in the
database after renaming some projects (in "Clean up project database" i saw
some projects twice)...

Any ideas how to fix the cube building process without backing up and
deleting all the projects? (I have about 50-60 projects in DB and the
account managers would not like it to restore the projects from a local
backup

Any advise would be appriciated...

Thanx,

Jan Davidek

 

[Gary Chefetz [MVP]]

Jan:

This error most often occurs when the Project Server installation is
experiencing the problem in the article below:
http://support.microsoft.com/default.aspx?scid=kb;en-us;812639

If you accidentally created a duplicate key in your database manipulations,
you'll need to address that in the same way you created it. Otherwise, you
may be blaming yourself for a problem that arose coincidentally.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.