Problems with OLAP Cube

[Johnnie Rotten]

Hello,

I'm trying to schedule a cube build and failing miserably. I've set PWA to
build the cube weekly and am receiving a message in the Application Event
Log & on the PWA page that kicks off the cube build:

=================================================
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 9/7/2004
Time: 3:47:12 PM
User: NT AUTHORITY\SYSTEM
Computer: PROJECTSRV
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1052
Description: Error #: 457 Desc. :This key is already associated with an
element of this collection
=================================================

I've tried to process the database and received an error that the table and
received the following errors on MSP_CUBE_PROJECTS:

=================================================
Processing Dimension 'Project List' failed. No changes have been made to the
database.

Processing error [Source data contains no rows] 'Project List'S' ;
Time:9/7/2004 4:36:51 PM

The SQL statement was SELECT DISTINCT "MSP_CUBE_PROJECTS"."PROJ_NAME" FROM
"MSP_CUBE_PROJECTS"
=================================================

 

[Gary L. Chefetz \(MVP\)]

Johnnie:

You have database corruption in the form of duplicate keys. You need to
repair the database before the cube will build.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[Johnnie Rotten]

Ok, what do I use to repair the data base? We've reviewed the tables and
found no obvious incorrect entries.

-jay

Johnnie:

You have database corruption in the form of duplicate keys. You need to
repair the database before the cube will build.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

Hello,

I'm trying to schedule a cube build and failing miserably. I've set PWA to
build the cube weekly and am receiving a message in the Application Event
Log & on the PWA page that kicks off the cube build:

=================================================
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 9/7/2004
Time: 3:47:12 PM
User: NT AUTHORITY\SYSTEM
Computer: PROJECTSRV
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1052
Description: Error #: 457 Desc. :This key is already associated with an
element of this collection
=================================================

I've tried to process the database and received an error that the table and
received the following errors on MSP_CUBE_PROJECTS:

=================================================
Processing Dimension 'Project List' failed. No changes have been made to the
database.

Processing error [Source data contains no rows] 'Project List'S' ;
Time:9/7/2004 4:36:51 PM

The SQL statement was SELECT DISTINCT "MSP_CUBE_PROJECTS"."PROJ_NAME"
FROM
"MSP_CUBE_PROJECTS"
=================================================

 

[Gary L. Chefetz \(MVP\)]

Johnnie:

There's no magic wand for this. You need to dig deeper and find the dupes.
They're most likely in the web assignments table, if that helps you narrow
it down, but no guarantees on that either. Once you find the culprit plan or
plans, you can remove them from the server and bring them back in again to
eliminate the duplicates.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

Ok, what do I use to repair the data base? We've reviewed the tables and
found no obvious incorrect entries.

-jay

Johnnie:

You have database corruption in the form of duplicate keys. You need to
repair the database before the cube will build.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

Hello,

I'm trying to schedule a cube build and failing miserably. I've set

PWA
to

build the cube weekly and am receiving a message in the Application Event
Log & on the PWA page that kicks off the cube build:

=================================================
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 9/7/2004
Time: 3:47:12 PM
User: NT AUTHORITY\SYSTEM
Computer: PROJECTSRV
Description:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1052
Description: Error #: 457 Desc. :This key is already associated with an
element of this collection
=================================================

I've tried to process the database and received an error that the table and
received the following errors on MSP_CUBE_PROJECTS:

=================================================
Processing Dimension 'Project List' failed. No changes have been made

to
the

database.

Processing error [Source data contains no rows] 'Project List'S' ;
Time:9/7/2004 4:36:51 PM

The SQL statement was SELECT DISTINCT "MSP_CUBE_PROJECTS"."PROJ_NAME"
FROM
"MSP_CUBE_PROJECTS"
=================================================

 

[Johnnie Rotten]

Gary,

Using the date the cube stopped building successfully we back tracked and
found the published project causing the congestion. Removing the project
enabled a successful cube build. I found a previous post from you stating
that MSPJ SP1 will resolve future issues. I plan to install the SP as soon
as possible.

Thanks for your help.

-johnnie

=============================

This error indicates that you have duplicate projects published on your
server. This is a known issue with unpatched 2002 installations. Find and
delete the duplicates, then install SP1. --- Please don't cross post to
every group.

There's no magic wand for this. You need to dig deeper and find the dupes.
They're most likely in the web assignments table, if that helps you narrow
it down, but no guarantees on that either. Once you find the culprit plan or
plans, you can remove them from the server and bring them back in again to
eliminate the duplicates.