OpsMgr : The value provided for the report parameter 'EndDate_BaseValue' is not valid for its type. (rsReportParameterTypeMismatch)

Hi,

A few weeks ago I was asked by a customer why he couldn't drilldown in the "OpsMgr Scheduled Reports" that he received weekly/monthly. He used the rendering format "HTML 4.0" which means that he received a HTML document containing the report, values used within the report and with reference to the report server (Microsoft SQL Reporting service SRS) to drill further down. Drilling down in these "OpsMgr Scheduled Reports" may result in error like this:

- "The value provided for the report parameter 'EndDate_BaseValue' is not valid for its type. (rsReportParameterTypeMismatch)"

The HTML document contains all parameters used to create the report like start time, end time and etc..

 

Issue

The issue is caused by a "Time format" difference between the client and the report server. In Denmark the date and time format is "dd-MM-yyyy" and the United States another format like "m-d-yyyy" is used.

If you see the picture below you will see that the client will pass the client date format as a parameter in the URL. The issue occurs even though the "ParameterLanguage" is also passed?

 

Workaround

Change the Regional Settings on the client to match the server.

Please find a guide here: http://windows.microsoft.com/en-US/windows-vista/Change-the-country-or-region-setting

Reference

ParametersLanguage = http://blogs.msdn.com/b/bradsy/archive/2006/04/04/568295.aspx

 

Marnix Wolf  mentions a similar issue in this article:

http://thoughtsonopsmgr.blogspot.com/2009/09/drilldown-error-in-opsmgr-r2-reporting.html

http://thoughtsonopsmgr.blogspot.com/2009/08/error-attempted-to-perform-operation.html

 

/Peter

Tags:

blog comments powered by Disqus