Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 904750 - Last Review: October 27, 2006 - Revision: 1.1
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
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.
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.
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:
- Locate the Microsoftsms2003reports.xml report file in the %SystemDrive%\Program Files\Microsoft Operations Manager 2005\Management Packs folder.
- Back up a copy of the Microsoftsms2003reports.xml report file to another location.
- Open the Microsoftsms2003reports.xml report file in Notepad.
- On the Edit
menu, click Find, type <ReportParameter Name="BeginDate"> in
the Find what box, and then click Find
Next.
- 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. - On the Edit
menu, click Find, type <ReportParameter Name="EndDate"> in
the Find what box, and then click Find
Next.
- 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. - 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.
To download the SMS 2003
Management Pack, visit the following Microsoft Web site:
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
| kberrmsg kbtshoot kbprb KB904750 |
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