Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 309604 - Last Review: October 22, 2003 - Revision: 3.1
PRB: DTS Report Preparation Task Fails When You Apply Commerce Server 2000 SP1
This article was previously published under Q309604
After you apply Commerce Server 2000 Service Pack (SP1), the Data Transformation Services (DTS) Report Preparation task fails.
Commerce Server 2000 SP1 reports all problems that it experiences during the Report Preparation task through an error event in the application event log.
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.
- In the Retail_dw database (Data Warehousing database), open the CubeProcInfo table, and then delete the row BuyerVisits.
- In the Commerce Server 2000 Microsoft Management Console (MMC), open Analysis Services, expand <your
computer name>, and then expand Retail_dw (Data Warehouse).
- Remove the BuyerVisits cube.
- Remove the shared dimension Advertiser.
The DTS Report Preparation task now runs fine.
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=301580/EN-US/
)
PRB: Event ID: 45057 No Rows in Source Data Occurs When You Apply Commerce Server 2000 SP1
APPLIES TO
- Microsoft Commerce Server 2000 Standard Edition
- Microsoft Commerce Server 2.0
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate