Deploy cumulative updates (Project Server 2007)

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

This article provides guidance to IT professionals managing deployment of cumulative updates to a Microsoft Office Project Server 2007 deployment. Office Project Server 2007 cumulative updates can be downloaded from the Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkID=24367). Project Server Cumulative Update Knowledge Base articles can be found on the Office Project Server 2007 Solutions Center page (https://go.microsoft.com/fwlink/?LinkID=91430).

What are cumulative updates?

Cumulative updates are a new method of providing hotfix releases on a scheduled delivery basis for Office Server products, including Office Project Server 2007. Through this model, Office hotfixes are released every two months in the form of a downloadable package of current and previous hotfixes. The primary goal is to deliver high-quality fixes on a predictable schedule. The updated releases are accompanied by a Knowledge Base article describing the contents of the update. The first Project Server cumulative update was released in August, 2008.

The hotfixes found in a cumulative update include:

  • Fixes for issues that meet Office hotfix acceptance criteria. These criteria include workaround availability, customer impact, reproducibility, the complexity of the code that must be changed, and other criteria. These criteria have not changed.

  • Any critical on-demand hotfixes released to date.

  • Any critical security or non-security updates released publicly to date.

Cumulative updates apply to all versions of Office that are currently in mainstream support. For general information about Microsoft product support, visit the Microsoft Support Lifecycle Web site)( https://go.microsoft.com/fwlink/?LinkId=147498).

Plan to install Project Server cumulative updates

Install a Project Server cumulative update to fix a specific problem you may be experiencing in your Project Server deployment. We recommend that you review Project Server cumulative updates as they are released to determine if any of the issues that are fixed are affecting your environment. Note that Project Server cumulative updates contain fixes from any previous cumulative update packages. Therefore, if you install the latest cumulative update to fix a problem you are currently experiencing, then you are also applying hotfixes from previously released cumulative updates. Always refer to the cumulative update's Knowledge Base (KB) article for details about what it contains and for any required dependencies.

Although Windows SharePoint Services cumulative updates are not a requirement for installing Project Server 2007 cumulative updates, you should consider applying them to your environment as well if you are experiencing any problems. You can install Cumulative updates for Windows SharePoint Services or Office SharePoint Server at the same time as the Project Server cumulative update, eliminating the need to rerun the SharePoint Products and Technologies Configuration Wizard more than once per server. (For more information, see Installation steps later in this article.)

Note that Office Project Professional 2007 cumulative updates are released on a cycle similar to that of the Project Server 2007 cumulative updates. In most cases you are not required to install Office Project Professional 2007 client cumulative updates in correspondence with a specific Project Server cumulative update. (See the Cumulative update dependencies required for the Project Server 2007 Infrastructure Update section of this article for more information about one possible exception). However, as a best practice, read the associated knowledge base article about each cumulative update for any dependencies that may exist.

Cumulative update server packages for Project Server 2007 farms deployed with Office SharePoint Server 2007

For Microsoft Office Project Server 2007 farms deployed with Microsoft Office SharePoint Server 2007, cumulative update server packages are now available to help eliminate the confusion associated with the installation order of various Windows SharePoint Services 3.0 and Office SharePoint Server 2007 cumulative updates. A cumulative update server package consists of a package that contains the latest of every hotfix patch that Microsoft has shipped for a particular version of a product. A customer would simply need to install the latest Windows SharePoint Services 3.0 cumulative update server package and the latest Office SharePoint Server 2007 cumulative update server package for the installation to be complete. The Office SharePoint Server 2007 cumulative update server package contains the latest Office Project Server 2007 cumulative update, so there is no need to install anything other than those cumulative update server packages on a Office Project Server 2007 farm deployed with Office SharePoint Server 2007.

Rollup cumulative updates are installed in the same manner as the Project Server cumulative update. Use the same installation steps as described in this article.

Installation requirements

Office Project Server 2007 Service Pack 1 is a prerequisite for installing any Office Project Server 2007 cumulative updates. Microsoft highly recommends that you install Office Project Server 2007 Service Pack 2 (SP2) prior to installing any Office Project Server 2007 cumulative updates dated April 2009 or later. (Office Project Server 2007 SP1 fixes are also included in Office Project Server 2007 SP2). For more information about installing Office Project Server 2007 service packs, see Deploy Service Pack 1 for Office Project Server 2007 and Deploy Service Pack 2 for Office Project Server 2007.

Before you begin

Before you install a cumulative update to your Project Server 2007 deployment, take these recommended actions:

  • Back up the farm databases before you start the installation. Cumulative updates cannot be uninstalled, so if you need to return to your previous deployment, you will need to restore the backed up databases.

  • Stop the World Wide Web Publishing Service (w3svc) on all the Web servers to disconnect all the users from the server farm. In server farms with multiple front-end Web servers, end users will not be able to browse the Web sites when files and databases have been updated on the first front-end Web server while the other Web servers still contain previous files and databases.

  • As a best practice, stop the Project Queue service prior to installing a cumulative update. This ensures that nothing will process while the update is being installed, and it prevents you from having to reboot the computer upon completion of installation.

Update a basic installation

Note

Cumulative updates need to be installed manually. Automatic Updates will not automatically apply cumulative updates to a basic installation of Project Server 2007 (that is, the single-server installation with Microsoft SQL Server Desktop Engine).

To install a Project Server cumulative update on a basic installation of Project Server 2007, do the following:

  1. Disconnect users from the server by stopping the World Wide Web Publishing service (w3svc) on the server.

  2. Download the Project Server cumulative update file. Run the file. On the Microsoft Software License Terms page, read the terms and click Click here to accept the Microsoft Software License Terms. Click Continue to install the update files.

  3. The next page reminds you to run the SharePoint Products and Technologies Configuration Wizard after installation of the files is finished. Click OK to acknowledge this and begin the installation.

  4. When installation of the files is done, on the confirmation page, click OK.

  5. Run the SharePoint Products and Technologies Configuration Wizard to complete the installation. To do so, click Start, click Administrative Tools, and then click SharePoint Products and Technologies Configuration Wizard.

  6. On the Configuration Successful page, click Finish.

  7. Make the server available to users by manually starting the World Wide Web Publishing Service (w3svc).

Update a farm deployment

Important

You cannot use Automatic Updates to install any cumulative updates on Office Project Server 2007.

For Office Project Server 2007 farm deployments, visit the Microsoft Download Centerto download and then install the update on each server in your farm.

Installation steps

To update an Office Project Server 2007 server farm deployment with a cumulative update, you must perform the following steps:

  1. On all servers in the farm, install the Project Server Cumulative Update files, but do not run the SharePoint Products and Technologies Configuration Wizard.

  2. On one server in the farm (preferably the one hosting the Central Administration site), run the SharePoint Products and Technologies Configuration Wizard to complete the installation on that server.

  3. Run the SharePoint Products and Technologies Configuration Wizard on all remaining servers on the farm.

We recommend that you use SharePoint Central Administration v3 application pool account credentials to run the SharePoint Products and Technologies Configuration Wizard. If you then use a different account to install the update, that account must be a domain account with the following rights and permissions:

  • Member of the Administrators group on the Web server computer

  • Member of the Administrators group on the SQL Server computer

You can install the update by logging on to the server directly or by connecting through a terminal services console session.

Note

For information on how to use console sessions, read the Microsoft Knowledge Base article How to connect to and shadow the console session with Windows Server 2003 Terminal Services(https://go.microsoft.com/fwlink/?LinkID=98317&clcid=0x409).

Install a cumulative update for Project Server in a farm deployment

  1. Disconnect users from the server farm by stopping the World Wide Web Publishing service (w3svc) on all Web servers.

  2. Download the Project Server cumulative update file. You will need to install the files on each server in your Office Project Server 2007 farm.

  3. On a server in the farm, run the file. At the Microsoft Software License Terms page, read the terms and click Click here to accept the Microsoft Software License Terms. Click Continue to install the update files.

  4. The next page that appears reminds you to run the SharePoint Products and Technologies Configuration Wizard after the files are installed. Click OK to acknowledge and begin the installation.

    Important

    After installing the files, do not run the SharePoint Products and Technologies Configuration Wizard. Start the wizard only after installing all update files to the server.

  5. When installation of the files completes, on the confirmation page, click OK.

  6. You must run setup to install new update files for every server in your server farm. If you have multiple servers in your server farm, go to each server in your Office Project Server 2007 farm and repeat steps 2-5 to install the files.

    Note

    If you are also installing cumulative updates for Windows SharePoint Services or Office SharePoint Server, you can install the files now to all servers on the farm. However, do not run the SharePoint Configuration Wizard on any of the servers at this point.

  7. After installing the update files on each server in the farm, go to each application server and stop the Microsoft Office Project Server Queue service (if available). If the services are not stopped, a reboot may be required at completion of setup.

  8. Use the server that hosts the Central Administration Web site to finalize the installation.

    Note

    We recommend that you finalize the software update installation first on the application server hosting the Central Administration Web site, then on the other application servers, and then on the front-end Web servers.
    If you host your Central Administration Web site on a front-end Web server, finalize the software update installation instead on that front-end Web server, then the application servers, and finally on the remaining front-end Web servers.

  9. On the server you selected in the previous step, run the SharePoint Products and Technologies Configuration Wizard to complete the installation. To run the SharePoint Products and Technologies Configuration Wizard, click Start, click Administrative Tools, and then click SharePoint Products and Technologies Configuration Wizard.

    Important

    All cumulative update installation files should be installed to all servers in the farm prior to running the SharePoint Products and Technologies Configuration Wizard. This ensures that all instances of Windows SharePoint Services are stopped on all servers so that no attempts are made to access the databases during the update.

  10. On the Configuration Successful page, click Finish.

    Important

    It is important that the SharePoint Products and Technologies Configuration Wizard perform its configuration procedures on only one computer at a time. The only exception is if you have detached your content databases and upgraded them before you reattach them to the server farm. For more information, see Deploy software updates for Windows SharePoint Services 3.0.

  11. When the cumulative update installation and configuration is complete on all the servers in the server farm, make the Web servers available to users by manually starting the World Wide Web Publishing Service (w3svc) on each server on which you manually stopped the service.

Verify the installation

There are three ways that you can verify the success of the installation process:

  • After you install the cumulative update, review the upgrade log file and verify that the updates to the Web applications were successful.

  • Another method for determining whether the Project Server Cumulative Update is installed on the computer is to view "Add or Remove Programs" in Control Panel to see if it is listed in the Currently installed programs list. Make sure that Show Updates is selected or the updates will not display. Look under Microsoft Office Project Server 2007 for hotfixes from the Project Server cumulative update. The hotfix files should be identified with a KB number that corresponds to the specific cumulative update (for example Hotfixes for Office (KB957696) will correspond to the October Project Server cumulative update).

  • You can also verify if Office Project Server 2007 has been updated by querying the VERSIONS table in one of the Office Project Server 2007 databases. This process is described in the procedure that follows.

View Project Server version information in a VERSIONS table

  1. On the computer running the instance of SQL Server containing the Office Project Server 2007 databases, open SQL Server Management Studio.

  2. Click New Query.

  3. Choose one of the Office Project Server 2007 databases from the Available Databases drop-down list.

  4. Type select * from versions in the query window and then click Execute.

    The most recent version number in the Version field should correspond to the cumulative update file. The TimeStamp value should correspond to when the update was applied.

Uninstalling cumulative updates

Project Server cumulative updates cannot be uninstalled. Therefore it is important that you back up your farm databases before applying any cumulative updates.

Important

As mentioned at the beginning of this article, when planning to install a cumulative update, be prepared to backup and restore your farm databases in case a problem should occur during the installation.

Cumulative update dependencies required for the Project Server 2007 infrastructure update

When you are preparing to incorporate a cumulative update, be sure to read the associated knowledge base article to determine whether any dependencies exist for that specific release. An important one to note is that the October 28, 2008 Project Server 2007 cumulative update does not include the Project Server 2007 infrastructure update. However, subsequent Project Server cumulative updates (starting with December 16, 2008) do include the Project Server infrastructure update.

One of the dependencies for installing any cumulative update that includes the Project Server infrastructure update is that the Project 2007 infrastructure update needs be installed to all Project Professional 2007 client computers. For example, let's say you install the December 2008 Project Server 2007 cumulative update and the accompanying Project Server 2007 infrastructure update that is included in this cumulative update (assuming the infrastructure update has not been installed previously). You would then need to apply the Project 2007 Infrastructure Update to all Project Professional 2007 client computers that connect to the server (assuming it has not been installed previously through an update to the clients). You can install the Project 2007 Infrastructure Update directly through the Microsoft Download Center, or you can install it through a Project 2007 cumulative update, because it is included in Project Professional 2007 client cumulative updates.

The reason for this requirement is that the client and the server’s scheduling engine’s method for calculating Fixed Duration tasks has changed. Therefore, to ensure that Fixed Duration tasks are calculated in the same way on the server and client, install the corresponding infrastructure update on each. Failure to apply the corresponding client update may cause data inconsistencies between Project Web Access and Project Professional 2007.

One method for verifying whether this requirement has been met is to check the hotfix level of both Office Project Server 2007 and Office Project Professional 2007. If Office Project Server 2007 is at or greater than hotfix version 952000, it has the infrastructure update installed. If Office Project Professional 2007 is at or greater than hotfix version 952067, it has the client infrastructure update installed. You can check for hotfix levels for both Office Project Server 2007 and Office Project Professional 2007 by viewing the Currently installed programs and updates list in "Add or Remove Programs" in Control Panel.

The following table provides examples of when the Project 2007 clients need to be updated after installing a cumulative update on Office Project Server 2007:

If you are applying this server update And this client update has already been applied Then the client dependency is

October 28, 2008 Project Server Cumulative Update

<none>

None. (The infrastructure update is not required on the client because this particular cumulative update does not install the infrastructure update on the server).

December 16, 2008 Project Server Cumulative Update

<none>

The December 16, 2008 Cumulative Update for Project 2007 must be applied to all Project Professional 2007 client computers.

December 16, 2008 Project Server Cumulative Update

Infrastructure Update for Project 2007

None. (The Infrastructure Update for Project 2007 is already on the Project Professional 2007 client computers).

March 6, 2009 Project Server Cumulative Update

December 16, 2008 Project 2007 Cumulative Updates

None. (The Infrastructure Update for Project 2007 is already on the Project Professional 2007 client computers).

Note

For more information about the Project Server 2007 Infrastructure Update, see Deploy the infrastructure update for Office Project Server 2007. For information about the features and enhancements included with the Project Server 2007 Infrastructure Update, see Project Server 2007 Infrastructure Update Release.

See Also

Concepts

Deploy Project Server 2007 updates

Other Resources

Description of the Project Server 2007 hotfix package: May 29, 2008 (https://go.microsoft.com/fwlink/?LinkId=142306)
Description of the Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): October 28, 2008 (https://go.microsoft.com/fwlink/?LinkId=142307)
Description of the Project Server 2007 hotfix package: December 16, 2008 (https://go.microsoft.com/fwlink/?LinkId=142304)
Description of the Project Server 2007 hotfix package: March 6, 2009 (https://support.microsoft.com/kb/968271)
Cumulative update packages for the 2007 Microsoft Office core suite applications and for 2007 Microsoft Office servers: December 16, 2008 (https://go.microsoft.com/fwlink/?LinkId=142305)
Description of the standard terminology that is used to describe Microsoft software updates (https://go.microsoft.com/fwlink/?LinkId=142308)