Force Rebuild of the Project Server Reporting Database

Background

The Microsoft Office Project Server 2007 Reporting database can become corrupt at times causing general queue job failures when publishing projects when invoking the Reporting message processor throwing exceptions that cite FOREIGN KEY constraint conflicts. Sometimes these are spurious and random in nature, and you can correct them simply by forcing a rebuild of the Project Server 2007 Reporting database.

Resolution

To force a rebuild of the Project Server 2007 Reporting Database, follow these steps:

1. Logon to Project Web Access with Administrator credentials
2. Select Administrative Backup from the Database Administration section on the Server Settings Page in Project Web Access
3. In the Items for Backup section of the Backup page, select the checkbox for Enterprise Custom Fields and then click the Backup button and click the OK button when prompted by the system
4. Select Administrative Restore from the Database Administration section on the Server Settings Page in Project Web Access
5. Choose Enterprise Custom Fields from the Choose Item selector on the Restore page
6. Click the Restore button and then click the OK button when prompted by the system

Allow time for the reporting rebuild job to run. You can track the state of this job on the Manage Queue page.