Deleted Old Projects still showing up - Project Server 2007

D

drevil

I have deleted several projects and rebuilt the olap cube. Those old
projects are still showing up in reports. Does someone know how to stop
these from showing up?
 
S

Sharry Heberer [MSFT]

Did you delete the project from both the Draft and the Publish DBs? If you
did, then you should check your Queue to make sure you see 3 types of delete
jobs for that particular project (Use the "By Project" filter so you will
only see jobs for that project). The three jobs you should see are 2 for
"Project Delete" (there are 2 because there is 1 for the Draft DB and 1 for
the Publish DB) and 1 for "Reporting Project Delete". All 3 of these need
to be in the Success state, with no failures. If there is any failure, then
the project did not get deleted from the Reporting DB. If this is the case,
please post back here and let me know.

If all 3 jobs were completed successfully, then it might be possible that
you just built the Cube before the Reporting Project Delete job had been
placed in the Queue. You'd have to be pretty fast-fingered to do this, but
if your Queue was very busy at the time of the deletion, then it's
theoretically possible to do this. If all 3 project delete jobs are
successful, try building your Cube again to see if the problem goes away.

Hope this helps,
Sharry
 
D

drevil

I don't see any delete jobs for any of the projects. I did notice that the
new projects entered are not showing up in reports, just the old ones. Could
I be building the Olap cube successfully but for some reason it is still
drawing off a previously built cube?
 
S

Sharry Heberer [MSFT]

If it has been more than a week, then failed Queue jobs will have been
deleted from the Queue to keep the Queue tables short.

As for whether you could be pulling data from a previously built cube, I
doubt it, but I don't have enough expertise in this area to know for sure.

Try this:
Look in your Draft DB. Is the project still in MSP_PROJECTS? If so, then
the Project Delete from the Draft DB failed and this is the reason the
projects are still in the Cubes. If not, then:

Look in your Publish DB. Is the project still in MSP_PROJECTS? If so, then
the Project Delete from the Publish DB failed and this is the reason the
projects are still in the Cubes. If not, then:

Look in your Reporting Database. Is the project still in MSP_Epm_Project?
If so, then the Project Delete from the Reporting DB failed and this is the
reason the projects are still in the Cubes. If not, then:

It must be a problem with the building of the Cubes. Unfortunately I don't
have the expertise to help out in this situation. First check to make sure
the Queue jobs for Cube Building are succeeding. Then I would suggest
examining all your Cube Settings and the Cubes themselves in AS and see if
there is anything peculiar, like the date the cube was built maybe.


--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
D

drevil

We looked through the database and didn't see any of the projects in the
tables. There is no sign of the old projects in "Manage Queue" I don't know
where the olap cube is being built...is there a way to manually delete it.
I've tried renaming the cube and building it and that didn't work either.
Also, is there a way to access several cubes?
 
S

Sharry Heberer [MSFT]

If the project is not in the project tables of any of the 3 databases
(Draft, Published, and Reporting), then it seems there is a problem with
cube building. Have you checked your Queue for errors for cube building?
Cube building is outside my realm of expertise, unfortunately.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
D

drevil

Yes, no errors. Can you point me to where the cube is being built? I'd like
to try manually deleting it.
 
S

Sharry Heberer [MSFT]

The Cube is being built wherever your Project Server admin set it up. You
should contact the admin to find this information out - it would be on your
Analysis Server.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Top