Microsoft KB Archive/301580

= PRB: Event ID: 45057 &quot;No Rows in Source Data&quot; Occurs When You Apply Commerce Server 2000 SP1 =

Article ID: 301580

Article Last Modified on 10/17/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q301580



SYMPTOMS
The Data Transformation Services (DTS) Prepare Report task may generate an EventID: 45057 &quot;No Rows in Source Data&quot; error after you install Commerce Server 2000 Service Pack 1 (SP1).



CAUSE
A &quot;No Rows in Source Data&quot; error message is returned by Analysis Services when an object is processed, and the underlying object in SQL Server contains no rows.

The Commerce Server 2000 SP1 version of the Report Preparation task is able to handle cube processing errors that the Commerce Server 2000 RTM version can not. Because the error code returned for &quot;No Rows in Source Data&quot; by Analysis Server 2000 is a generic error that covers many error conditions, the Report Preparation task cannot identify and safely ignore the error.



RESOLUTION
To resolve this problem, do the following:
 * Remove any cubes or dimensions from the OLAP database for which there is no data in the underlying fact or dimension tables.
 * Remove any references to the deleted cubes from the CubeProcInfo table located in the SQL Server Commerce Server Data Warehouse.

Keywords: kbprb KB301580

-

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

© Microsoft Corporation. All rights reserved.