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

Article translations Article translations
Article ID: 904750 - View products that this article applies to.
Expand all | Collapse all

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 <ReportParameter Name="BeginDate"> in the Find what box, and then click Find Next.
  5. Change <DataType>String</DataType> to <DataType>DateTime</DataType> if the line after <ReportParameter Name="BeginDate"> is <DataType>String</DataType>.

    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.
  6. On the Edit menu, click Find, type <ReportParameter Name="EndDate"> in the Find what box, and then click Find Next.
  7. Change <DataType>String</DataType> to <DataType>DateTime</DataType> if the line after <ReportParameter Name="EndDate"> is <DataType>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.
  8. 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.

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

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 904750 - Last Review: October 27, 2006 - Revision: 1.1
APPLIES TO
  • Microsoft Operations Manager (MOM) 2005
Keywords: 
kberrmsg kbtshoot kbprb KB904750

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com