Summary
This article describes the Office Communications Server 2007 R2 database issues that are fixed in the cumulative update package for Microsoft Office Communications Server 2007 R2 that is dated July, 2010.
Note Additionally, this update package applies to the Microsoft SQL Server scripts in Office Communications Server 2007 R2.
Note Additionally, this update package applies to the Microsoft SQL Server scripts in Office Communications Server 2007 R2.
This article describes the following items about the update package:
- The issues that the update package fixes.
- The prerequisites for installing the update package.
- Whether you must restart the computer after you install the update package.
- Whether the update package is replaced by any other update package.
- Whether you must make any registry changes.
- The files that the update package contains.
INTRODUCTION
This cumulative update also includes the following previously released update:
- 983567 The update process fails when you install the cumulative update package that is described in KB article 979857
- 981215 Chat channels become unavailable in Office Communications Server 2007 R2 Group Chat client
- 981247 Office Communication Server 2007 R2 and SQL Server report frequent SQL deadlocks
- 972725 Error message when you try to join a “My Meeting” conference in Communications Server 2007 R2: "sorry; unable to transfer you into the conference"
- 978377 Error message when you install the Office Communications Server 2007 R2 database update package that is dated July, 2009: "Error 1722"
- 978362 You experience performance issues in Office Communications Server 2007 R2 when many legacy presence users are converted to enhanced presence users at the same time
More Information
You must install the cumulative update that is described in this article. Otherwise, the Office Communications Server 2007 R2 services may not start after you install the following cumulative update:
Download the OCS2009-DBUpgrade.msi package now.
Release Date: July 2010
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
Before you install this update, Office Communications Server Front End Service (rtcsrv) must be stopped.
Installation information depends on the server role that you apply the database update to.
Communications Server 2007 R2 Standard Edition
Install this update on any of the following servers that are running Office Communications Server 2007 R2:
Office Communications Server 2007 R2 Enterprise Edition (EE)
You can install the database update from the Office Communications Server 2007 R2 Enterprise Edition back-end, or from the Office Communications Server 2007 R2 Enterprise Edition front-end. However, we recommend that you install the database update from the Office Communications Server 2007 R2 Enterprise Edition back-end.
To install the database update for Office Communications Server 2007 R2 Enterprise Edition, type the following command:
Note If you have moved the database from a server that is running office Communications Server 2007 R2 (Back-End) that had update 2032834 installed to a new server that is running Communications Server 2007 R2 (Back-End), you must reapply update 2032834 to the new server.
Office Communications Server 2007 R2 Standard Edition
Remove the update listing for this update package from Add or Remove Programs on any of the following servers that are running Office Communications Server 2007 R2:
Add or Remove Programs, run the OCS2009-DBUpgrade.msi file.
Note Click OK when you receive the following message:
Office Communications Server 2007 R2 Enterprise Edition
Remove the update listing for this update package from
Add or Remove Programs on any of the following servers that are running Office Communications Server 2007 R2:
Add or Remove Programs from the back-end of a Microsoft SQL Server server, run the following command:
Note Click OK when you receive the following message:
After the update is installed, the global version of this update has the file attributes, or a later version of the file attributes, that are listed in the following table:
983472 Description of cumulative update for Office Communications Server 2007 R2: July, 2010
Update package information
Microsoft Download Center
The following file is available for download from the Microsoft Download Center:Download the OCS2009-DBUpgrade.msi package now.Release Date: July 2010
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file. By contacting support
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problems that are described in this article. Apply this hotfix only to systems that are experiencing the problems described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
Prerequisites
To apply this update package, you must have the following applications installed:- Office Communications Server 2007 R2 Administration Tools
- SQL Client Tools
- If you install SQL 2008 Client Tools, you must also install SQL 2005 SP2 Backward Compatibility.
Before you install this update, Office Communications Server Front End Service (rtcsrv) must be stopped.
Restart requirement
You may have to restart the computer after you apply this update package.Update package replacement information
This hotfix package replaces hotfix package 983568.- 983568 Description of the cumulative update package for Office Communications Server 2007 R2 database: May, 2010
Registry information
To use one of the update packages in this package, you do not have to make any changes to the registry.Update package installation information
Note Before you install this update, Office Communications Server Front End Service (rtcsrv) has to be stopped.Installation information depends on the server role that you apply the database update to.
Communications Server 2007 R2 Standard Edition
Install this update on any of the following servers that are running Office Communications Server 2007 R2:
- Standard Edition Server
- Director (Standard Edition)
Office Communications Server 2007 R2 Enterprise Edition (EE)
You can install the database update from the Office Communications Server 2007 R2 Enterprise Edition back-end, or from the Office Communications Server 2007 R2 Enterprise Edition front-end. However, we recommend that you install the database update from the Office Communications Server 2007 R2 Enterprise Edition back-end.
To install the database update for Office Communications Server 2007 R2 Enterprise Edition, type the following command:
OCS2009-DBUpgrade.msi POOLNAME=Poolname
Where Poolname is the Enterprise Edition Pool name. Note If you have moved the database from a server that is running office Communications Server 2007 R2 (Back-End) that had update 2032834 installed to a new server that is running Communications Server 2007 R2 (Back-End), you must reapply update 2032834 to the new server.
Removal information
This update cannot be removed. To remove the update, you must remove and then reinstall Communications Server 2007 R2. The following instructions only help you remove the update listing from Add or Remove Programs in Control Panel.Office Communications Server 2007 R2 Standard Edition
Remove the update listing for this update package from Add or Remove Programs on any of the following servers that are running Office Communications Server 2007 R2:
- Standard Edition Server
- Director (Standard Edition)
Add or Remove Programs, run the OCS2009-DBUpgrade.msi file.
Note Click OK when you receive the following message:
Warning 25000. This update package made changes to the database schema that cannot be removed. If you proceed, you will remove the update package from the Add/Remove Programs list, but the changes will remain in the database schema. Do you want to proceed?
Office Communications Server 2007 R2 Enterprise Edition
Remove the update listing for this update package from
Add or Remove Programs on any of the following servers that are running Office Communications Server 2007 R2:
- Enterprise Edition (Back-end)
- Director (Enterprise Edition) Back-end
Add or Remove Programs from the back-end of a Microsoft SQL Server server, run the following command:
OCS2009-DBUpgrade.msi POOLNAME=poolname
Where Poolname is the Enterprise Edition Pool name. Note Click OK when you receive the following message:
Warning 25000.This update package made changes to the database schema that cannot be removed. If you proceed, you will remove the update package from the Add/Remove Programs list, but the changes will remain in the database schema. Do you want to proceed?
File information
This update may not contain all the files that you must have to fully update a product to the latest build. This update contains only the files that you must have to correct the issues that are listed in this article.After the update is installed, the global version of this update has the file attributes, or a later version of the file attributes, that are listed in the following table:
| File name | File version | File size | Date | Time | Platform |
|---|---|---|---|---|---|
| Dbcommon.sql | Not Applicable | 20,226 | 29-Jun-2009 | 11:55 | Not Applicable |
| Dbqfeupdate.wsf | Not Applicable | 11,847 | 30-Jun-2010 | 08:06 | Not Applicable |
| Dbrtc.sql | Not Applicable | 1,088,267 | 30-Jun-2010 | 13:47 | Not Applicable |
| Dbrtcdyn.sql | Not Applicable | 28,793 | 30-Jun-2010 | 13:47 | Not Applicable |
| Dbsetup.wsf | Not Applicable | 108,595 | 30-Jun-2010 | 13:47 | Not Applicable |
| Dbupgrade.wsf | Not Applicable | 38,934 | 29-Jun-2009 | 06:29 | Not Applicable |
| Roles.sql | Not Applicable | 838 | 30-Jun-2010 | 13:47 | Not Applicable |
| Types.sql | Not Applicable | 541 | 30-Jun-2010 | 13:47 | Not Applicable |
References
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about the latest updates for Communications Server 2007 R2, click the following article number to view the article in the Microsoft Knowledge Base:968802 Updates for Communications Server 2007 R2