Microsoft KB Archive/904750

= You receive an &quot;An error has occurred during report processing&quot; error message if you try to run an SMS 2003 report in the MOM 2005 Reporting Console =

Article ID: 904750

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-





SYMPTOMS
If you try to run a Microsoft Systems Management Server (SMS) 2003 report in the Microsoft Operations Manager (MOM) 2005 Reporting Console, you receive the following error message:

An error has occurred during report processing. (rsProcessingAborted)

Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)

Arithmetic overflow error converting expression to data type datetime

This symptom occurs if the following conditions are true:
 * You run the SMS 2003 report that uses the BeginDate and the EndDate parameters.
 * You run the SMS 2003 report on a computer where the Standards and formats setting is not set to use to English [United States]. For example, you run the SMS 2003 report on a computer where the Standards and formats setting is set to use English [United Kingdom].

Note You adjust the Standards and formats setting in the Regional and Language Options tool in Control Panel.



CAUSE
This problem occurs because the SMS 2003 reports incorrectly interpret the BeginDate and the EndDate parameters. This problem only occurs with the SMS 2003 reports that are included in the SMS 2003 Management Pack for MOM 2005 version 05.0.2753.0000.



RESOLUTION
To resolve this problem, modify the Microsoftsms2003reports.xml report file that is included in the SMS 2003 Management Pack for MOM 2005, and then import this report file.

To perform this task, follow these steps:
 * 1) Locate the Microsoftsms2003reports.xml report file in the %SystemDrive%\Program Files\Microsoft Operations Manager 2005\Management Packs folder.
 * 2) Back up a copy of the Microsoftsms2003reports.xml report file to another location.
 * 3) Open the Microsoftsms2003reports.xml report file in Notepad.
 * 4) On the Edit menu, click Find, type  in the Find what box, and then click Find Next.
 * 5) Change String to DateTime if the line after  is String.

Note Perform this operation for each instance of BeginDate where DataType is String. There are 40 changes to make. Additionally, note the case sensitivity while you change this report file.
 * 1) On the Edit menu, click Find, type  in the Find what box, and then click Find Next.
 * 2) Change String to DateTime</DataType> if the line after <ReportParameter Name=&quot;EndDate&quot;> is String</DataType>.

Note Perform this operation for each instance of EndDate where DataType is String. There are 40 changes to make. Additionally, note the case sensitivity while you change this report file.
 * 1) Save the Microsoftsms2003reports.xml report file, and then import this report by using the Management Pack Import/Export Wizard in the MOM 2005 Administrator Console.

Note If a failure occurs when you try to import the report file, the failure may be caused by a spelling mistake or a use of an incorrect case in the report file.

<div class="moreinformation_section">

MORE INFORMATION
To download the SMS 2003 Management Pack, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=99834C12-FB4D-4174-A727-926D358CA593&displaylang=en

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: uk srs

Keywords: kberrmsg kbtshoot kbprb KB904750

-

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

© Microsoft Corporation. All rights reserved.