Microsoft KB Archive/309604

= PRB: DTS Report Preparation Task Fails When You Apply Commerce Server 2000 SP1 =

Article ID: 309604

Article Last Modified on 10/22/2003

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition
 * 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  , 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

Additional query words: SP1, Commerce Server 2000, DTS task, Report Preparation

Keywords: kbprb kbfaq KB309604

-

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

© Microsoft Corporation. All rights reserved.