Microsoft KB Archive/312506

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

Article ID: 312506

Article Last Modified on 10/12/2005

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q312506



SYMPTOMS
You may encounter various problems in Data Warehousing and Analytics. These problems only occur if the Sp2setup.exe file is version 1.0.0.1. The Sp2setup.exe file is located in the following folder:

\Update\CSUninstallSP2\

For additional information about the symptoms of this problem, refer to the Microsoft Knowledge Base articles in the References section.



CAUSE
These problems occur in the SQL code that upgrades to version 1.0.0.1 of Commerce Server 2000 Service Pack 2 (SP2).



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:

http://support.microsoft.com/contactus/?ws=support

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:  Back up your Data Warehouse Microsoft SQL Server and On-Line Analytical Processing (OLAP) databases. From the Windows Start menu, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer. 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. In SQL Query Analyzer, on the File menu, click Open, and then browse to the following folder:

\Program Files\Microsoft Commerce Server

 Click Undocs2ksp2.sql, and then click Open. 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.</li> On the Query menu, click Execute. Notice that the uninstall script runs and several caution messages appear in the Messages window.</li> After the uninstall script completes, close SQL Query Analyzer.</li> Run the Sp_analysis_upgrade.exe tool (which is located in the Commerce Server root directory).</li> Verify that there are no errors in the following file:

\SP2\Backup\Cs2ksp2_ _upgrade.log

</li> 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

</li> Run the report preparation task.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

MORE INFORMATION
The following messages in the upgrade log are benign:


 * dimension not found in Analysis database. Dimension: Campaign


 * dimension not found in Analysis database. Dimension: RegisteredUser


 * dimension not found in Analysis database. Dimension: Buyer Visits^RegisteredUser


 * dimension not found in Analysis database. Dimension: CustomerOrders

If you installed Commerce Server 2000 SP2 and then unpupped resources, you cannot uninstall the Commerce Server 2000 service pack. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

312566 PRB: Cannot Uninstall Commerce Server 2000 Service Pack

<div class="references_section">