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!

The update application and verification process is encapsulated in the figure below. Click figure below to open. 

 Updated: 10th Jan 2010

MS KB Article	KB Date	Description Summary / Resolution	My Comments
977022 977028 977266 977023	December 15, 2009             December 15, 2009               December 15, 2009         December 15, 2009	Windows SharePoint Services 3.0 Cumulative Update Server hotfix package (Sts-x-none.msp): December 15, 2009 Some key issues fixed; 1.    After you create a calculated column that includes a reference to the hidden ID column in a Windows SharePoint Services 3.0 environment, the CPU usage increases to 100%. 2.    When you upload some files to a Windows SharePoint Services 3.0 Discussion Board, multiple duplicated discussion items appear unexpectedly. 3.    In a Windows SharePoint Services 3.0 site, after you add an additional choice to the Task Status site column, workflow tasks that have a Task Status of Completed cannot be viewed. <Refer to other fixes in the associated KB> Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): December 15, 2009 Some key issues fixed; 1.    When you change the calendar for a resource, the actual work that is already reported is recontoured. 2.    When you change the base calendar for a resource, the total actual work value for an assignment remains the same. However, the dates on which the work appears are changed. 3.    If there are no resources assigned to a task, assignment views display the incorrect number of work hours in Microsoft Office Project Web Access.A queue save job takes a long time to finish. This problem typically occurs when projects are very large and have many defined custom fields. <Refer to other fixes in the associated KB> Project 2007 hotfix package (Project-x-none.msp): December 15, 2009 This hotfix fixes the following key issues; 1.    When you copy and paste a duration column to another duration column, all assignment-level actual work changes to zero. The task-level actual work remains unchanged. 2.    Remaining Work is recalculated for some tasks when some actual work is entered in a different task. 3.    The Free Slack value is calculated incorrectly for two linked tasks that have Finish No Later Than and Start No Earlier Than constraints. <Refer to other fixes in the associated KB> SharePoint Server 2007 Cumulative Update Server hotfix package (Coreserver-x-none.msp): December 15, 2009 Some key issues fixed; 1.    If a profile import occurs during the time that domain controllers in a domain are unavailable, the profiles for that domain are marked as "Profiles missing from import." 2.    Issue with Alternate Access Mapping 3.    A Date type cell in a .xlsx file is treated as a Number type cell by the IFilter component when the cell to the left of the Date type cell has a style applied but does not contain a value. <Refer to other fixes in the associated KB	High recommended considering the issues fixed in WSS, Project Server and Project especially resource calendar issue. Process for existing deployments; SP2 + Dec CU Process for NEW deployments; RTM + SP2 + Dec CU Apply this CU only if you are encountering types of issues fixed.
975002 974990 975923 974988	October 27, 2009 October 27, 2009 October 27, 2009 October 27, 2009	Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts-x-none.msp): October 27, 2009 Some key issues fixed; 1.    You run a crawl for some Lists or Surveys, and you receive access violation error messages 2.    You upload a file to a Windows SharePoint Services 3.0 site, and the custom content type that you selected from the New menu is not used 3.    You encounter performance problems when you run a crawl on a Windows SharePoint Services 3.0 site 4.    Users who have read permission do not receive alerts for drafts or for minor version documents when the Content Approval option is enabled in a Windows SharePoint Services 3.0 site <Refer to other fixes in the associated KB> Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): October 27, 2009 Some key issues fixed; 1.    If you add specific fields to the Summary view on the Resource Assignments page, the view is broken and cannot be displayed. The following fields cause this problem: Task ID, Unique ID, Outline Number, and Duration. 2.    When you add lines to a timesheet that contains custom fields, the data in the custom fields is lost. 3.    An Active Directory sync fails if the enterprise custom fields have default values. 4.    When you try to save a resource plan, the resource plan cannot be saved. 5.    The Project Web Access regional setting issue <Refer to other fixes in the associated KB> Project 2007 hotfix package (Project-x-none.msp): October 27, 2009 1.    This hotfix fixes the following key issues; You assign cost resources and work resources, or material resources and work resources to the same task in Office Project 2007 and tasks are in progress. After you publish a project, the Reporting (Project Publish) queue job takes a long time to be completed. 2.    You expand a sub project from a master project and make a change. Then, you open the same sub project by itself within the same session. You cannot save the sub project. Additionally, Office Project 2007 crashes. <Refer to other fixes in the associated KB> Prerequisites You must have 2007 Microsoft Office suite Service Pack 2 or 2007 Microsoft Office suite Service Pack 1 installed to apply this hotfix package. SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): October 27, 2009 This hotfix contains Project Server 2007 updates. Prerequisites To install this hotfix, you must have 2007 Microsoft Office Servers Service Pack 2 or 2007 Microsoft Office Servers Service Pack 1 installed.	Apply this HF only if you are affected for example WSS crawl, mixed resource assignment save time issue etc. I would recommend not mixing the resource types on same tasks. Process for existing deployments; SP2 + Oct CU Process for NEW deployments; RTM + SP2 + Oct CU Apply this CU only if you are encountering types of issues fixed.
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.

Author: PJ Mistry