FIX: Errors in Data Warehouse and Analytics After You Upgrade to Commerce Server 2000 SP2 (312506)

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next version of Commerce 2000 service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later:

   Date         Time    Version    Size     File name
   -------------------------------------------------------
   13-Jun-2001  11:08   1.0.0.1    28,944   Hotfixsetup.exe
   10-Nov-2001  18:21                 577   Qfehotfix.ini
   11-Nov-2001  16:59             133,120   Qfepatch.msp
   11-Nov-2001  17:01               7,168   Qfeunpatch.msp
				

After you install the hotfix, follow these steps to resolve this problem:

1. Back up your Data Warehouse Microsoft SQL Server and On-Line Analytical Processing (OLAP) databases.
2. From the Windows Start menu, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
3. In the Connect to SQL Server dialog box, in the drop-down list, select the SQL Server with which you want to connect. In the Connect using section, type the required authentication information, and then click OK.
4. In SQL Query Analyzer, on the File menu, click Open, and then browse to the following folder:

   Server_Name\Program Files\Microsoft Commerce Server

5. Click Undocs2ksp2.sql, and then click Open.
6. On the SQL Query Analyzer toolbar, in the Database drop-down list, select the data warehouse database for the site that you are running the uninstall script.
7. On the Query menu, click Execute. Notice that the uninstall script runs and several caution messages appear in the Messages window.
8. After the uninstall script completes, close SQL Query Analyzer.
9. Run the Sp_analysis_upgrade.exe tool (which is located in the Commerce Server root directory).
10. Verify that there are no errors in the following file:

    Commerce_Server_Root\SP2\Backup\Cs2ksp2_sitename_upgrade.log

11. Set the appropriate permissions for the mscsDateIntersect cube and mscsVisit virtual cube.For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

    312528 PRB: Default Permissions Are Not Set for OLAP or Analysis Services

12. Run the report preparation task.