PRB: DTS Report Preparation Task Fails When You Apply Commerce Server 2000 SP1 (309604)


The information in this article applies to:

  • Microsoft Commerce Server 2000
  • Microsoft Commerce Server 2.0
This article was previously published under Q309604

SYMPTOMS

After you apply Commerce Server 2000 Service Pack (SP1), the Data Transformation Services (DTS) Report Preparation task fails.

CAUSE

Commerce Server 2000 SP1 reports all problems that it experiences during the Report Preparation task through an error event in the application event log.

RESOLUTION

If some Commerce Server resources are not being used, you will see error messages in the event log when the cubes that access this nonexistent data are processed. If you do not want to see these error messages, you must remove empty cubes and shared dimensions.

NOTE: The following solution uses the Retail sample site as an example.

  1. In the Retail_dw database (Data Warehousing database), open the CubeProcInfo table, and then delete the row BuyerVisits.
  2. In the Commerce Server 2000 Microsoft Management Console (MMC), open Analysis Services, expand <your computer name>, and then expand Retail_dw (Data Warehouse).
  3. Remove the BuyerVisits cube.
  4. Remove the shared dimension Advertiser.
The DTS Report Preparation task now runs fine.

MORE INFORMATION

When the Report Preparation DTS task finds errors in processing the cubes, it reports these to the event log and then continues to process the other cubes. It does not stop processing when a single error is found. If one error is reported, the task reports a failure when the task is complete.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

301580 PRB: Event ID: 45057 No Rows in Source Data Occurs When You Apply Commerce Server 2000 SP1

Modification Type:MajorLast Reviewed:10/22/2003
Keywords:kbprb KB309604
©2003 Microsoft Corporation. All rights reserved.