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:
-
Logon to Project Web Access with Administrator credentials
-
Select Administrative Backup from the Database
Administration secton on the Server Settings Page in Project
Web Access
-
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
-
Select Administrative Restore from the Database
Administration secton on the Server Settings Page in Project Web Access
-
Choose Enterprise Custom Fields from the Choose Item
selector on the Restore page
-
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.