Default Behavior for Open Visits Changed for Commerce Server (250366)



The information in this article applies to:

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

This article was previously published under Q250366

SUMMARY

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.

MORE INFORMATION

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.

Modification Type:MajorLast Reviewed:11/17/2003
Keywords:kbinfo KB250366 kbAudDeveloper