Reporting Date Range Error with Italian Locales

One of the most annoying error I encountered during my SCOM career is bound to report generation from console executed on client/server with italian locales. Every time a report is generate from the console this error pops up:

 

Below the additional informations:

 Date: 18/06/2014 16:26:50

Application: Operations Manager

Application Version: 7.1.10226.0

Severity: Error

Message: Cannot execute report. 

System.ArgumentOutOfRangeException: Value of ’01/01/0001 00:00:00′ is not valid for ‘Value’. ‘Value’ should be between ‘MinDate’ and ‘MaxDate’.

Parameter name: Value

   at System.Windows.Forms.DateTimePicker.set_Value(DateTime value)

   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.Controls.RelativeDateTimePicker.LoadRelativeDateValues(ComboBox dateEditor, DateTimePicker timeEditor, ReportParameterInfo dateBaseTypeParameter, ReportParameterInfo dateBaseValueParameter, ReportParameterInfo dateOffsetTypeParameter, ReportParameterInfo dateOffsetValueParameter)

   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.Controls.RelativeDateTimePicker.LoadValues(ReportParameterInfoCollection reportParameters)

   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.Controls.RelativeDateTimeBusinessPicker.LoadValues(ReportParameterInfoCollection reportParameters)

   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.LoadValues()   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.OnRenderingCompleteJob(Object sender, ConsoleJobEventArgs args)

Changing the system locales of the system running the console “solves” the problem. I tried three different locales (Italian Switzerland, French France and English United States) and all these locales have no problems in generating reports.

The odd thing is that while Italian Switzerland and ENU locales present differences in date formats, French date formats seem exactly the same as Italian – Italy one:

This issue has been known since a lot of time but it’s not on top of product team priority list (maybe due to the fact that it’s probably limited to Italian locales only), but unfortunately reports are of interest of management too and the option locales may become less “easy to be accepted”… so, let’s wait and hope for a definitive solution to locales bug hitting these products that have worldwide diffusion.