Thanks to Rob and the Office Sustained Engineering team, and of course the product group, we now have the December 2009 CU for the Office clients and servers, including Project Server 2007.
The biggest area of fixes in this release relate to changes in the handling of administrative time, actual work and calendar exceptions – and this is embodied in fixes on both the server and client. Best to patch both to this release to get the full benefit of these fixes, but this isn’t a requirement and will not break anything if you stagger the loading of client and server patches.
In Rob’s words, first some details of getting ready to apply the CU, with either SP1, or preferably SP2, and then the CUs themselves:
This CU include a number of fixes, so Microsoft strongly recommends that you test this in a test environment based on your production environment before putting this fix live in production.
The article below provides information on how to deploy the Project Server Cumulative Update.
Deploy cumulative updates (Project Server 2007)
We strongly recommend that you install WSS and Office Servers 2007 Service Pack 2. The KB articles below provide information on how to download and install SP2 if you have not already done so.
Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2
Description of 2007 Microsoft Office servers Service Pack 2 and of 2007 Microsoft Office servers Language Pack Service Pack 2
Description of Office Project 2007 Service Pack 2 (SP2) and of Office Project Language Pack 2007 Service Pack 2 (SP2)
The server patches require that WSS and Office Servers 2007 SP1 be installed. For clarity, SP1 is required and SP2 is strongly recommended. Here are the links to the SP1 Server Patches for your convenience:
Description of the 2007 Microsoft Office servers Service Pack 1 and the 2007 Microsoft Office servers Language Pack Service Pack 1
How to deploy the 2007 Microsoft Office servers Service Pack 1 and Office Server Language Pack 2007 Service Pack 1
The Server CU is released in two different versions. The first version is in Individual Packages specific to a particular product like WSS and Project Server. These are smaller downloads but they do not include language packs or patches for other products so patches for those products would have to be downloaded and installed separately.
The second version is the Server Rollup Packages. This is a set of two rollup packages which contains all the fixes for WSS, Project Server and MOSS. These packages should be used when MOSS is part of the deployment and/or you have language packs installed. The Server Rollup Packages are much larger (~200MB each) but they will greatly simplify MOSS patch deployment.
You can read about the fixes included in the December CU from the following articles:
Note: This CU contains an important fix for a group of Actual Work issues surrounding Administrative Time and Calendars. There are fixes for this issue in both the Client and Server patches. As such, we strongly recommend that you install both the Client and Server patches from this CU. This is not a patch requirement, however, as there will be no added negative effects if only the server or client are patched. You will just not have the whole fix until both patches are installed.
Server Rollup Packages:
Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (WSS server-package): December 15, 2009
Description of the Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): December 15, 2009
Individual Product Packages:
Description of the Windows SharePoint Services 3.0 Cumulative Update Server hotfix package (Sts-x-none.msp): December 15, 2009
Description of the Office Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): December 15, 2009
Description of the Office Project 2007 hotfix package (Project-x-none.msp): December 15, 2009
Whether Dec 09 CU contains OCT 09 CU too?
It would be a great help if you could comment on this.
Hello Brian. Can you tell me if this update include all the others cumulative updates?
Previously, I did a download of October Server Rollup CU of Sharepoint and the download had ~420 Mb.
Today, I've download the December release of Server Rollup CU of Sharepoint, but the size was ~380 Mb. Is this correct ?
First of all my apologies if i pasted the issue at wrong place. Kindly have a look and guide me is there any patch available to fix these issues on Project Server 2007 (SP2 with April CU + SQL Server 2005 SP3 with April CU)
How come it is possible that one ResourceUID have two different ResourceNameUID in Project Server 2007.
Whereas, SDK gives complete different definition i.e. GUID (ResourceNameUID uniqueidentifier(36) of dbo.MSP_TimesheetResource)of the resource name, remains constant even though the resource name can change.
(SELECT COUNT(*) AS Expr1
WHERE (StartDate >= '7/1/2009') AND (EndDate <= '12/31/2009')) AS TotalPeriods,
(SELECT COUNT(*) AS FilledTimesheet
FROM MSP_TimesheetResource INNER JOIN
MSP_Timesheet ON MSP_TimesheetResource.ResourceNameUID = MSP_Timesheet.OwnerResourceNameUID INNER JOIN
MSP_TimesheetPeriod ON MSP_Timesheet.PeriodUID = MSP_TimesheetPeriod.PeriodUID
WHERE (MSP_Timesheet.TimesheetStatusID = 3) AND (MSP_TimesheetPeriod.StartDate >= '7/1/2009') AND
(MSP_TimesheetPeriod.EndDate <= '12/31/2009') AND
(MSP_TimesheetResource.ResourceUID = MSP_EpmResource_UserView.ResourceUID)) AS TotalApproved
FROM MSP_TimesheetResource RIGHT OUTER JOIN
MSP_EpmResource_UserView ON MSP_TimesheetResource.ResourceUID = MSP_EpmResource_UserView.ResourceUID
WHERE (MSP_EpmResource_UserView.ResourceIsActive = 1)
Group BY MSP_EpmResource_UserView.ResourceName,MSP_EpmResource_UserView.ResourceUID
Having Count(*) >1
ResourceUID = A282D49A-FFC6-40C7-8664-4E35E0842BFD
ResourceName = Abid Mahmood
Timesheet Associated (ResourceNameUID = D854908D-C433-4116-949E-3601B6905A2F )= 1
Timesheet Associated (ResourceNameUID = E6673ADA-922F-4B80-84C8-837DB0AF1506 )= 39
ResourceUID = 0580CC81-8772-4480-939C-91DE212A7825
ResorceName = Anwar Hussain
Timesheet Associated (ResourceNameUID = 41D18550-4134-454A-9424-345C3AFB5DB6) = 5
Timesheet Associated (ResourceNameUID = ACB45DFF-7437-42E2-BF90-383F18BD175D)= 16
ResourceUID = B2D5408F-C0F6-4E81-8375-ACC079CFA0A5
ResorceName = Abdul Aziz Farooqi
Timesheet Associated (ResourceNameUID = 56AC5B96-620E-4B87-A887-2B273AF8E399) = 12
Timesheet Associated (ResourceNameUID = 0073EE1D-7CE9-4B53-A916-E837BD21182F)= 9
Similarly, a very strange thing which I have seen and totally confused is how come it is possible that a task percentage is 100% completed with a value in actualfinishdate
SELECT MSP_EpmResource_UserView.ResourceUID, MSP_EpmResource_UserView.ResourceName, COUNT(DISTINCT MSP_EpmTask.ProjectUID)
AS TotalProjects, COUNT(MSP_EpmTask.TaskUID) AS TotalTasks,
SUM(CASE WHEN AssignmentBaseline0FinishDate = AssignmentActualFinishDate THEN 1 ELSE 0 END) AS OnTime,
--SUM(CASE WHEN TaskPercentCompleted = 100 THEN 1 ELSE 0 END) AS AllCompleted,
--SUM(CASE WHEN TaskPercentCompleted = 100 And Not AssignmentBaseline0FinishDate = TaskActualFinishDate THEN 1 ELSE 0 END) AS DelayedCompleted,
SUM(CASE WHEN AssignmentActualFinishDate > AssignmentBaseline0FinishDate THEN 1 ELSE 0 END) AS LateFinish,
SUM(CASE WHEN AssignmentActualFinishDate < AssignmentBaseline0FinishDate THEN 1 ELSE 0 END) AS EarlyFinish,
SUM(CASE WHEN AssignmentActualStartDate Is Not Null And AssignmentActualFinishDate Is Null And AssignmentPercentWorkCompleted <100 THEN 1 ELSE 0 END) AS InProgress,
SUM(CASE WHEN AssignmentActualStartDate Is Null THEN 1 ELSE 0 END) AS NotStarted,
SUM(CASE WHEN AssignmentActualFinishDate Is Null And AssignmentPercentWorkCompleted = 100 THEN 1 ELSE 0 END) AS StrangeCondition,
SUM(CASE WHEN AssignmentActualFinishDate Is Not Null And AssignmentPercentWorkCompleted < 100 THEN 1 ELSE 0 END) AS Ambigious
FROM MSP_EpmTask INNER JOIN
MSP_EpmAssignment_UserView ON MSP_EpmTask.ProjectUID = MSP_EpmAssignment_UserView.ProjectUID AND
MSP_EpmTask.TaskUID = MSP_EpmAssignment_UserView.TaskUID INNER JOIN
MSP_EpmResource_UserView ON MSP_EpmAssignment_UserView.ResourceUID = MSP_EpmResource_UserView.ResourceUID
GROUP BY MSP_EpmResource_UserView.ResourceUID, MSP_EpmResource_UserView.ResourceName
ORDER BY MSP_EpmResource_UserView.ResourceName
ResourceName=Aamir A- Rehman Thanawala
Thanks in advance for your support
Hi Susan and Jeanblu,
CUs are cumulative, so will include the previous releases. I can't comment on the size change, but review the KB and it will also tell which files are included. Perhaps an additional change reduced one of the file sizes between the releases.
The timesheet data is a true data warehouse. Have any of your users changed due to AD changes? This might lead to a difference in the UIDs. I can't think of any other explanation. If you still have issues or need more information then a support incident might help.
This artical is very useful for me. I am a Share Point developer and always looking to learn something new. I would like to introduce another good SharePoint blog, Have a look.
Happy New Year Brian
Will there be a Service Pack Release in Jan 2010 for Project & Project Server 2007? Thanks, Mary
Greetings! Happy New Year!
Question: Can a older Server CU (say DEC 2008 CU) work with a newer client CU (say SP2+Aug2009CU)?
We are at Dec 2008 CU, planning to go to SP2+Aug2009 CU in the next month. This is to satisfy our Desktop engineering group who have asked for a UAT test of SP2-Aug2009CU Client ActiveX update. They want to verify prior to deployment that client update does not break existing apps on the workstation. My concern is if we deploy client update (SP2-Aug2009CU), before server update, they would not be able to access the production system. Valid concern?
Well, yesterday Microsoft release the Febraury 2010 Cumulative Update. Here is the link.
The version is 12.0000.6529.5000.
Greeting for all!!!