Monday, December 29, 2008

Rebuild the Project Server Reporting Database

In a previous post, I discussed patching the Project Server 2007 farm to resolve several issues in the server and client side applications. The patching process is quite lengthy, but resolves a lot of common issues, even if you haven’t noticed them. One of the issues which is resolved is Project Server Reporting not matching what is in Project Server Published. You might notice this in a timesheet comparison report or if you are comparing timesheet actual time to actual time in the project plan.

Once you have patched the server, you can simply rebuild the Project Server Reporting database. Keep in mind that although this is a simple process, it can take a long time and is very resource intensive…so after hours or weekends.

So, here’s how to do it:
Create a backup
1. Logon to the Project Web Access Site as a PWA Administrator
2. From the Quick Launch menu, select Server Settings
3. Under the Database Administration heading, select Administrative Backup. Note, we are going to initiate a restore to trigger the rebuild, so we are backing up to make sure we have the latest information and not overwrite the environment with older information.
4. Select Enterprise Custom Fields and select Backup

You can check the Queue to make sure the job completed successfully.
1. From the Server Settings screen, under the Queue heading, select Manage Queue
2. Click the ‘+’ next to Job Completion States to expand the section
3. From the Available Job States, select Success and then Add>
4. From the Job Grid select Refresh Status
5. You should see a Job Type named Archive Custom Fields with a Job State of Success and % of 100%

Perform a Restore
1. Once your backup job has completed, from the Server Settings screen, under the Database Administration heading, select Administrative Restore
2. From the Item, select Enterprise Custom Fields and click Restore

You can check the Queue to make sure the job completed successfully.
1. From the Server Settings screen, under the Queue heading, select Manage Queue
2. Click the ‘+’ next to Job Completion States to expand the section
3. From the Available Job States, select Success and then Add>
4. From the Job Grid select Refresh Status
5. You should see the following Job Types named:

  • Restore Custom Fields
  • Reporting Database Refresh
  • Reporting (Fiscal Periods Sync)
  • Reporting (Resources Capacity Range Sync

When all of the job types have completed 100% Successful, then your Project Server Reporting Database has been rebuilt. At this point, all of your data between Project Server Published and Reporting should match.

2 comments:

  1. Dear Sir,
    I did exactly the described procedure, but unfortunaltely there was no update to the reporting database, Although it was showing that the reporting database was rebuilt.
    What may be other reasons?

    ReplyDelete
  2. To resolve such type of project server file corruption problems you can use :- http://www.filesrecoverytools.com/project-server-recovery.html

    ReplyDelete