This update affects the following user-agent reference tables:
- UserAgentBrowserCategory
- UserAgentOperatingSystem
- UserAgentPortal
- UserAgentSecurity
- UserAgentVersion
Additionally, this update updates the
csdw_makeuseragentdata stored procedure that uses the user-agent reference data to populate tables and cubes that are in the site user reporting.
Update information
Prerequisites
You must have Commerce Server 2007 Service Pack 2 (SP2) or Commerce Server 2009 installed to apply this update.
Restart requirement
You do not have to restart the computer after you apply this update.
Update replacement information
This update does not replace any other updates.
File information
The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.For all supported versions of Commerce Server 2007
| File name | File version | File size | Date | Time | Platform |
|---|
| Csdwschema.sql | Not applicable | 3,749,720 | 13-Nov-2009 | 11:04 | Not applicable |
| Csreports.sql | Not applicable | 235,244 | 13-Nov-2009 | 11:28 | Not applicable |
For all supported versions of Commerce Server 2009
| File name | File version | File size | Date | Time | Platform |
|---|
| Csdwschema.sql | Not applicable | 3,749,720 | 16-Nov-2009 | 11:15 | Not applicable |
| Csreports.sql | Not applicable | 235,244 | 16-Nov-2009 | 11:39 | Not applicable |
Installation notes
After you extract the hotfix package, you obtain the following files.
For Commerce Server 2007- CommerceServer2007SP2-KB976523-ENU.exe
- Csdwuaupdate.sql
- Hotfix.txt
For Commerce Server 2009- CommerceServer2007SP3-KB976523-ENU.exe
- Csdwuaupdate.sql
- Hotfix.txt
Install the CommerceServer2007SP2-KB976523-ENU.exe file to update the user-agent reference data and the stored procedures for Commerce Server 2007.
Install the CommerceServer2007SP3-KB976523-ENU.exe file to update the user-agent reference data and the stored procedures for Commerce Server 2009.
Additionally, you must run the Csdwuaupdate.sql file against the existing Commerce Server data warehouse database to update the user-agent reference data and the related stored procedures.