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
