OLAP Cube Build Error

[Michelle Moulliet]

Does anyone know what this error means? I got it when trying to build my cube.

The cube scheduled to be built on 3/1/2006 at 3:51 PM failed.
(457) This key is already associated with an element of this collection

Thanks!
Michelle

 

[Marc Soester]

Hi Michelle,

I cant tell you what the error message means, but I can tell you how to
solve it

What we do is
Go the Analysis Server
Delete the Project Server Database
go to PWA Admin and rebuild the cube,
go back to the OLAP , apply right user groups and you are up and running again
( I hope )
Hope this helps

 

[Gary L. Chefetz [MVP]]

Michelle:

If Marc's solution is not effective, it may indicate that you have some data
corruption in your system in the form of duplicate key data.

 

[Michelle Moulliet]

Thank you, Gary & Marc. I'll have my IT people try Marc's solution.

Also, any clue how I determine which key is 457 & might be a duplicate? I'd
like to provide some guidance regarding table and/or field to point my IT
staff to. If I know whether it's a resource or a project, I may be able to
fix it myself.

Thanks!
Michelle