61 – Deploy cumulative updates (Project Server 2007)
Updated: 2009-04-28
Table of Content
Deploy
cumulative updates (Project Server 2007).......................................................................... 2
What are cumulative updates?..................................................................................................... 2
Plan to install Project Server cumulative updates........................................................................ 2
Cumulative update server packages for Project Server 2007 farms deployed
with Office SharePoint Server 2007..................................................................................................................................................... 3
Installation requirements............................................................................................................. 3
Before you begin......................................................................................................................... 3
Update a basic installation........................................................................................................... 4
Update a farm deployment.......................................................................................................... 4
Installation steps...................................................................................................................... 4
Install a cumulative update for Project Server in a farm deployment............................................. 5
Verify the installation.................................................................................................................. 6
View Project Server version
information in a VERSIONS table............................................ 7
Uninstalling cumulative updates..................................................................................................... 7
Cumulative update dependencies required for the Project Server 2007
infrastructure update....... 7
See Also....................................................................................................................................... 8
Install cumulative updates sequence............................................................................................... 9
Step 1....................................................................................................................................... 9
Step 2....................................................................................................................................... 9
Step 3....................................................................................................................................... 9
Step 4....................................................................................................................................... 9
Step 5....................................................................................................................................... 9
Step 6....................................................................................................................................... 9
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
(http://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 (http://go.microsoft.com/fwlink/?LinkID=91430).
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)(
http://go.microsoft.com/fwlink/?LinkId=147498).
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.
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.
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 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.
Note:
|
For more information about how to
perform backups, read Prepare to back
up and restore a farm (Windows SharePoint Services 3.0) and Prepare to
back up and restore a Project Server 2007 farm. |
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 (Microsoft Office Project Server 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.
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).
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 Center to download and then install the update on each server in
your farm.
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 http://go.microsoft.com/fwlink/?LinkID=98317&clcid=0x409 |
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.
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.
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.
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. |
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. |
Concepts
Deploy Project
Server 2007 updates
Other
Resources
Description of the Project
Server 2007 hotfix package: May 29, 2008
(http://go.microsoft.com/fwlink/?LinkId=142306)
Description of the
Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): October 28,
2008 (http://go.microsoft.com/fwlink/?LinkId=142307)
Description of the
Project Server 2007 hotfix package: December 16, 2008
(http://go.microsoft.com/fwlink/?LinkId=142304)
Description of the Project
Server 2007 hotfix package: March 6, 2009
(http://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
(http://go.microsoft.com/fwlink/?LinkId=142305)
Description of the
standard terminology that is used to describe Microsoft software updates
(http://go.microsoft.com/fwlink/?LinkId=142308)
On the server hosting Central Administration, install the
binary files for the Windows SharePoint
Services 3.0 cumulative update. Do not run the SharePoint Products
and Technologies Configuration Wizard.
On the server hosting Central Administration, install the
binary files for the Project Server 2007
cumulative update. Do not run the SharePoint Products and Technologies
Configuration Wizard.
On all other servers in the farm,
install binary files for both the Windows
SharePoint Services 3.0 and Project
Server 2007 cumulative update. Do not run the SharePoint Products
and Technologies Configuration Wizard when installation of the binary files
concludes for both.
On the server hosting Central Administration, run the
SharePoint Products and Technologies Configuration Wizard.
On all remaining servers in
the farm, run the SharePoint Products and Technologies Configuration Wizard.
If required, install the
corresponding Project 2007
cumulative update to all Project
Professional 2007 computers that connect to the server (as per the
Infrastructure Update requirement).