SCOM reporting gives error when the AM / PM Symbol is incorrect in regional and langauge settings

Article ID: 961091 - View products that this article applies to.
Expand all | Collapse all
Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Symptom



SCOM reporting and SQL Server Reporting Services 2005 is installed on a machine whose regional and language setting is English New Zealand.  When you run the report from the SCOM console you get the following System Center Operations Manager 2007 error message:

 

Cannot execute report.

Value of ‘1/01/0001 12:00:00 AM’ is not valid for ‘Value’ should be between ‘MinDate’ and ‘MaxDate’.

Parameter name: Value

Cause



This happens because, the reporting services checks the local system where it finds the AM/PM symbol as AM PM. Whereas it expects it to be  a.m. / p.m.

 

When you open any *. rdpl files from http://localhost/reports/pages and look at the properties tab you see the AM/PM symbol as a.m. / p.m.

 

And the local machine symbol under regional and language setting shows as AM /PM

 

 

And the local machine symbol shows as AM /PM

Resolution



To resolve this issue, change the AM / PM symbol in regional and language settings to a.m. and p.m.

And then restart the computer.

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Properties

Article ID: 961091 - Last Review: December 11, 2008 - Revision: 1.0
APPLIES TO
  • Microsoft System Center Reporting Manager 2006
Keywords: 
kbnomt kbrapidpub KB961091

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