FIX: An update is available that updates the user-agent reference data to generate accurate site user reporting in Commerce Server 2007 and in Commerce Server 2009

Article translations Article translations
Article ID: 976523 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

An update is available for Microsoft Commerce Server 2007 and for Microsoft Commerce Server 2009.

In Commerce Server 2007 and in Commerce Server 2009, you can import Web server log files into the Commerce Server data warehouse. Web server log files contain user-agent strings. You can use the csdw_makeuseragentdata stored procedure together with the user-agent reference data that is in the data warehouse database to generate a report about operating system versions, browsers, browser versions, and search engine crawlers.

This update adds the latest information about operating systems, browsers, and search engines to the user-agent reference data. Additionally, the update updates the stored procedure to generate accurate site user reporting.

MORE INFORMATION

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
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Csdwschema.sqlNot applicable3,749,72013-Nov-200911:04Not applicable
Csreports.sqlNot applicable235,24413-Nov-200911:28Not applicable
For all supported versions of Commerce Server 2009
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Csdwschema.sqlNot applicable3,749,72016-Nov-200911:15Not applicable
Csreports.sqlNot applicable235,24416-Nov-200911:39Not 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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about Commerce Server data warehouses, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/dd464272(CS.90).aspx
For more information about user-agent strings, visit the following MSDN Web site:
http://msdn.microsoft.com/en-us/library/ms537503(VS.85).aspx

Properties

Article ID: 976523 - Last Review: October 7, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Commerce Server 2007 Developer Edition
  • Microsoft Commerce Server 2007 Enterprise Edition
  • Microsoft Commerce Server 2007 Standard Edition
  • Microsoft Commerce Server 2009 Enterprise
  • Microsoft Commerce Server 2009 Standard
Keywords: 
kbautohotfix kbexpertiseadvanced kbsurveynew kbqfe KB976523

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com