Microsoft KB Archive/250366

From BetaArchive Wiki
Knowledge Base

Default Behavior for Open Visits Changed for Commerce Server

Article ID: 250366

Article Last Modified on 11/17/2003


  • Microsoft Commerce Server 2002 Standard Edition
  • Microsoft Commerce Server 2000 Standard Edition
  • Microsoft Site Server 3.0 Standard Edition

This article was previously published under Q250366


In Site Server 3.0 Analysis, requests for open visits are stored in a local cache in Microsoft Site Server\Data\Analysis\Cache. In the Commerce Server Data Warehouse (DW), requests for open visits are imported into the Data Warehouse, and a log file is not used. At the end of an import, the open visit information is stored in the DW OpenUserVisit table so that this information can be referenced during the next import.


The default settings in Site Server 3.0 Analysis is to Commit all open visits to database at the end of an import. (This is configured in the Usage Import tool, Tools menu, Options, Log File Rotation tab.) The default behavior in Commerce Server is to Store open visits for next import. This setting may explain differences in visit counts when comparing the Site Server Analysis and Commerce Server results.

In Commerce Server 2000, the Rotation settings for log files are configured in the Properties for Web Server log import (Commerce Server) DTS (Data Transformation Services) task, Advanced settings, Log Files tab. Configuration setting changes here are stored in the site table in the DW database EndImportAction field. The setting here determines the rotation behavior:

  • 1 = Store open visits for next import.
  • 2 = Commit open visits to database.
  • 3 = Discard open visits.

Additional query words: cs2k com2k plutonium

Keywords: kbinfo KB250366