EPM2007 Updates Catalogue (Post SP2)

Here is a catalogue of key Microsoft Project Sever 2007 updates and KBs post SP2, organised in chronological order. All in one place!

Updated: 2nd Sep 2009 00:36

MS KB Article	KB Date	Description Summary / Resolution	My Comments
973410 WSS3 (Aug CU) 973937 PS2007 (Aug CU) 973930 P2007 (Aug CU)     973409 MOSS (Aug CU)	August 25, 2009 Rev: 1.0 August 25, 2009 Rev: 1.0 August 25, 2009 Rev: 1.1 August 26, 2009 Rev: 1.0	Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): Aug 25, 2009 This hotfix fixes the following key issues; custom site content types - cannot create a new child content type calculated column - "The SQL server might not be started" error message rename a folder name - the approval comments for the document are removed unexpectedly <Refer to numerous updates in the KB> Project Server 2007 hotfix (Pjsrvapp.msp & Pjsrvapp.msp): Aug 25, 2009 This hotfix fixes the following key issues; submitting more than 100 task updates gives error issue with Resource Assignment page Total field at the bottom of Timesheet view is incorrect because overtime work values are doubled Time-phased actual work is incorrect after you submit the actual working hours during nonworking time in PWA When you assign cost resources and work resources or assign material resources and work resources to the same task in Project 2007, the reporting publishing job takes a long time. <Refer to numerous updates in the KB> Note Before you apply the hotfix that is described in this article, delete temporary Internet files in Internet Explorer. Project 2007 hotfix (Project.msp): Aug 25, 2009 This hotfix fixes the following key issues; Inactive resources on 100% complete tasks on enterprise projects give warning message. Issue with editing views in Enterprise Global. SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): Aug 25, 2009 Still confirming if this includes Project Server Aug CU (973937). Note: the KB is still in progress and public download is not available yet (checked 2nd Sep).	I am currently testing this CU. Following successful testing, I will be recommending applying this Aug CU which resolves the Admin issue of Enterprise Global views etc.  Process for existing deployments SP2 + Aug CU Process for NEW deployments RTM + SP2 + Aug CU Apply this CU only if you are encountering types of issues fixed.
970946 WSS3 (Jun CU)   971502 PS2007 (Jun CU)             971501 P2007 (Jun CU)                 971537 MOSS (Jun CU)	3/07/2009 Rev 2.0 15/07/2009 Rev 1.0 01/07/2009 Rev 2.0 22/07/2009 Rev 2.0	Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): June 30, 2009 Key fixes include sub-site migration issues, issues with list with more than 500 items, issues with version control etc. Refer to numerous updates in the KB. Note: There is an additional WSS CU (971538) released end June for languages other than English. Project Server 2007 hotfix (Pjsrvapp.msp & Pjsrvapp.msp): July 15, 2009  The Tracking Method setting on the Task Settings and Display page is not applied to proposals or to converted proposals! In Resource Usage view, the total work for summary resource assignments under the Other Projects and Commitments sections is wrong. Issue with My Tasks page In Project Professional 2007, the values for actual work differ from the values that are submitted by resources after you accept updates for assignments. These incorrect values are displayed on the My Tasks page if you save and publish the project after the data is changed by accepting the updates for assignments. etc, refer to other details in the MS KB Project 2007 hotfix (Project.msp): June 30, 2009 This hotfix fixes the following issues; If an enterprise resource task assignment has 0 hours of work associated with it, the values that you see for the summary resource assignments under the Other Projects and Commitments sections in the Resource Usage view do not match. If projects have complex contours and large amounts of actual work, the save process to Project Server 2007 takes a very long time in Project Professional 2007. Performance is very slow when you insert custom field list items in the Japanese version of Project 2007 by using the CustomFieldValueListAdd Visual Basic for Applications (VBA) method . You have resource leveling set to automatic. You also have a VBA event code that is running. After the event code runs, leveling no longer occurs automatically. You create cross project links between tasks. When you change the scheduling of a task, the linked tasks are not updated. SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): July 15, 2009 Includes Project Server Jun CU (971502). If Project Server is deployed on a MOSS platform then apply this ‘combined’ MOSS update.	Apply this CU only if you are encountering types of issues fixed. If not, and you can wait until end Aug then I would recommend you apply the Aug CU which is earmarked to resolve the Admin issue of Enterprise Global views etc.  I will keep you posted on the Aug CU. Process for existing deployments SP2 + June CU Process for NEW deployments RTM + SP2 + June CU
2000241	01/07/2009	Queue Job Status shows "Waiting to be processed" and then never completes Cause; Although there may be other causes for this error, this issue can occur when the SQL retry limit value is set to 0. Resolution; To resolve this problem, set the SQL Retry Limit value to the default value of 5 and then restart the Microsoft Office Project Server Queue Service. To do this, follow these steps in the KB.	Apply the resolution if you are encountering this type of issue. Remember to also check if there any jobs that have may have failed and blocking correlation.
2000163	27/06/2009	In Microsoft Project Web Access, when a project is published and a Project Workspace is created by a project manager, other project managers at the same level in the Resource Breakdown Structure (RBS) structure do not have access to the newly created workspace. Resolution: Refer to Workaround options in the KB. Alternative Resolution: Add user to project team and assign to project say a ‘dummy’ task.	Does not affect you if your business processes dictates that PMs can only view edit own projects.
971620	26/06/2009	During the installation of the 2007 Microsoft Office servers Service Pack 2, a product expiration date is activated incorrectly.	If you have applied the manual fix then this does not concern you. Apply this patch only if affected. Apply SP2 + 968860 + 971620
971562	26/06/2009	In the Resource Usage view, the total work for the summary resource assignments under the Other Projects and Commitments sections is wrong.	Apply this patch only if affected. Apply SP2 + 968860 + 971562
2000144	16/06/2009	The tasks status indicator states "Update has not been submitted" even though the task is submitted. Resolution: In order to display the correct indicator next to the task, click My Tasks in the left navigation pane to refresh the page. Alternately, click away from the My Tasks page and then go back to the My Tasks page. When you do this, the red exclamation point disappears.	Update your internal end-user training material as appropriate.
971217	02/06/2009	The SharePoint Products and Technologies Configuration Wizard fails after you install any cumulative update or service pack for Project Server 2007 that was released in October 2008 or later	Highly recommended if you have a pre Oct 2008 patch level. Run the check script to identify potential upgrade issue.
971202	11/05/2009	Actual Work entered in My Tasks changes when Non-work time is entered in My Timesheets in Microsoft Project Web Access Cause; This problem may occur when the Non-Work time typed into the timesheet is entered as a calendar exception into the resource’s calendar. Creating a Non-Work entry makes the resource unavailable for work for a portion of the day. The Work is timephased across the entire day and not in a specific period, resulting in a change in the entered Actual Work for the same day. There may be an overlap of Work time entered in My Tasks and Non-Work time entered in My Timesheets. This problem occurs even if the total number of hours reported does not exceed the resource’s availability for that day. Workaround options; Project members should enter overhead time in “My Timesheets” BEFORE they enter the billable time “My Tasks”. OR Enter time in the “My Timesheet” category, then import it into “My Tasks” category using the Import Timesheet feature in Project Web Access.	Update your business processes as necessary to accommodate these workaround options.
971189	11/05/2009	Outlook freezes when typing an e-mail message when the Project Web Access add-in is installed	Apply this patch only if affected. Apply SP2 + 968860 + 971189
971066	13/05/2009	In Project 2007, the values for actual work differ from the values that are submitted by the resources after you accept updates for assignments. These incorrect values are displayed on the My Tasks page if you save and publish the project after the data is changed by accepting the updates for assignments.	Apply this patch only if affected. Apply SP2 + 968860 + 971066
968860 (Apr CU)	30/Apr/2009	Project Server 2007 Post SP2, April Cumulative Update (CU). Key fixes include; Issue with editing a custom field through PWA affecting booking type issue Milestone progress issue Issues with PWA > My Tasks page Issues with PWA updates and approval "Check-in pending" issue Review the full list in the KB for further details.	Highly recommended as this has has key updates. Apply SP2 + 968860

Note: This posting is provided "AS IS" with no warranties, and confers no rights.Test all updates thoroughly on a ‘replica’ development/test environment prior to applying on your production environment.