PWA 2007: Orphaned Project

P

Paul Goldmann

Hi,

I found a project duplicated in my OLAP Cube. Even after deleting it through
Delete Enterprise Objects from draft, published and archive database one
copy still shows up in the cube after I rebuild it. How do I delete this?

Thanks
Paul
 
B

Ben Howard

The OLAP cubes build off the reporting database. Can you check if the
project has been deleted from here
 
P

Paul Goldmann

Hi,

no, the orphaned project is also in the reporting database. Is there a way
to build the database from scratch? I have not found any resources for
troubleshooting the reporting database.

Thanks again
Paul
 
S

Sharry Heberer [MSFT]

There should be a failed queue job that tells why the project could not be
deleted from the reporting database. When the job is deleted from the
published database, a job is automatically put in the queue to remove it
from the reporting database. It seems that this job failed for some reason.
Is there such a failed job in the queue?
 
P

Paul Goldmann

Hi Sharry,

actually I can't tell. A couple of days later the Queue is empty.

How do I clean up the server. I had already deleted all projects through the
server settings.

Thanks again
Paul
 
S

Sharry Heberer [MSFT]

The default behavior for the Queue is that Successful jobs are deleted every
24 hours, while non-Successful jobs are deleted once a week. If the failure
happened more than a week ago, then the job will no longer be there. If the
failure happened less than a week ago, and you have not changed the default
settings of the Queue job retention policy, then you should be able to find
the reporting job which failed. If you have many jobs in your Queue, that
job may be several "pages" down. To easily see all remaining jobs for that
project, in the top filter on the Manage Queue page, you can select "By
Project" in which case a dropdown will appear with all the projects listed.
Select your project, then hit the Refresh button on the grid.

If you still don't see the failed reporting job, then we don't really have a
supported way to manually delete the job from the reporting database as of
now. You may check your Application Events as well - if the reporting job
failed, it would have also placed an event in the Application Events log.
 
S

sathya

*****Capture Project UID
SELECT [ProjectUID],[ProjectName]FROM [Projectserver_Reporting].[dbo].
[MSP_EpmProject]
WHERE PROJECTName LIKE '******'

*****Then open SQL Query Analyzer make sure you selected Project Reporting
Db then run the following stored procedure

MSP_Epm_DeleteResourcePlan 'Your Project UID'
MSP_Epm_DeleteProject 'Your Project UID'



*****Now Rebuild the OLAP Cube then check the status.
 
Top