Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

Project Server 2007: December 2009 CU Released!

Project Server 2007: December 2009 CU Released!

  • Comments 9

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)

http://technet.microsoft.com/en-us/library/dd239177.aspx

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

http://support.microsoft.com/kb/953338

Description of 2007 Microsoft Office servers Service Pack 2 and of 2007 Microsoft Office servers Language Pack Service Pack 2

http://support.microsoft.com/kb/953334

Description of Office Project 2007 Service Pack 2 (SP2) and of Office Project Language Pack 2007 Service Pack 2 (SP2)

http://support.microsoft.com/kb/953326

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

http://support.microsoft.com/kb/936984/en-us

How to deploy the 2007 Microsoft Office servers Service Pack 1 and Office Server Language Pack 2007 Service Pack 1

http://support.microsoft.com/kb/945013/en-us

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

http://support.microsoft.com/kb/977027

Description of the Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): December 15, 2009

http://support.microsoft.com/kb/977026

Individual Product Packages:

Description of the Windows SharePoint Services 3.0 Cumulative Update Server hotfix package (Sts-x-none.msp): December 15, 2009

http://support.microsoft.com/kb/977022

Description of the Office Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): December 15, 2009

http://support.microsoft.com/kb/977028

Description of the Office Project 2007 hotfix package (Project-x-none.msp): December 15, 2009

http://support.microsoft.com/kb/977266

Leave a Comment
  • Please add 4 and 1 and type the answer here:
  • Post
  • Hello Brian,

    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 ?

  • Hello Brain,

     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.

    Use ProjectServer_Reporting

    SELECT     MSP_EpmResource_UserView.ResourceName,MSP_EpmResource_UserView.ResourceUID,

                             (SELECT     COUNT(*) AS Expr1

                               FROM          MSP_TimesheetPeriod

                               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

    Query Results

    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

    Query Results

    1.

    ResourceUID= E74894DD-0A6B-4A4F-B1D2-6BE9B4490EF4

    ResourceName=Aamir A- Rehman Thanawala

    TotalProject=3

    TotalTasks=158

    OnTime=110

    EarlyFinish=2

    LateFinish=2

    InProgress=0

    NotStarted=36

    StrangeCondition=3

    Ambigious=0

    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.

    Best regards,

    Brian

  • Hi Hyderzaidi,

    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.

    Best regards,

    Brian

  • Hi,

    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.

    http://SharePointBank.com

    Harry

  • Happy New Year Brian

    Will there be a Service Pack Release in Jan 2010 for Project & Project Server 2007?  Thanks, Mary

  • Brian,

    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?

    Dinesh

  • Well, yesterday Microsoft release the Febraury 2010 Cumulative Update. Here is the link.

    The version is 12.0000.6529.5000.

    http://support.microsoft.com/kb/980427.

    Greeting for all!!!

Page 1 of 1 (9 items)