Project Server technical bits

** WARNING ** following this post may kill your already sickly farm.... Imagine the scenario: - during some troubleshooting, someone deletes some EPM databases that they believe no longer point to a PWA Site (but actually do) or - when deleting a PWA Site, some environmental issue interrupts the process before it completes or - an issue occurred during PWA Site provisioning or - who knows what, sometimes bad things happen...... what you will see: Sharepoint will continually report events such as : An exception occurred while running the job scheduler.   Reason: Cannot open database "ProjectServer_Published" requested by the login. The login failed.  Login failed for user xxxxxxxxxxxxxxxxx.  Technical Details: System.Data.SqlClient.SqlException: Cannot open database "ProjectServer_Published" requested by the login. The login failed.  Login failed for user xxxxxxxxxxxxxx     at System.Data.SqlClient.SqlInternalConne...

updated on 10 Dec 2010 - MS1-Var-P field names were wrong.  Hope Ive got it right this time!!! - Carl updated on 13 Dec 2010 - data types and task level rollups added to field definition (shame) Problem In the Project Centre you wish to show the status of your "Gateway" events that are held as Milestones in the project plans to provide a Milestone Summary view.  However there is no out of the box solution to doing this. The Approach Firstly you need a Task Level Custom Field that links to a lookup table that defines your milestones.  For Example: Field Name = C3_Milestone Type Lookup Table = Gateways LUT List = MS1, MS2, MS3, MS4, MS5 For each milestone you want to report on in the Project Centre (MS1...5), create the following field structure: Note:   -T represents task fields, -P represents project fields - MS1 Switch-T this is the control field that identifies the relevant task that is tagged with the Gateway = MS1 value (1), Baselined (2), Complete (4), ...

Post on its way soon (just testing)