Microsoft KB Archive/293317

= User Trends Report May Display Incorrect Data =

Article ID: 293317

Article Last Modified on 9/23/2005

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q293317



SYMPTOMS
A User Trends report may display incorrect data when you run two similarly dated imports on the same day.



CAUSE
The NewUsersByDate table contains new user counts that are correctly grouped by site ID and day. There is one row in this table for each combination of site ID and day.

The UsersByDate view contains user counts that are grouped by task history ID, site ID, and day. There is one row in this table for each combination of task history ID, site ID, and day.

The final view is a combination of the UsersByDate and NewUsersByDate tables that are grouped by date and site ID. This is incorrect, because the UsersByDate view can contain multiple rows per day, which can result in the number of new users on that day being included multiple times.



RESOLUTION
To resolve this problem, obtain the latest service pack for Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000. This problem was first corrected in Commerce Server 2000 Service Pack 1.



MORE INFORMATION
Installation Instructions:

Run the SQL script by using SQL Query Analyzer against the Data Warehouse database. The fix will not take effect until you run the Report preparation task again. This fix disables incremental processing of the Weekly User Trends cube; it will be processed as a refresh during an incremental run of the Report preparation task.

Keywords: kbqfe kbprb kbhotfixserver KB293317

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.