After DST change (US/Canada), when I run any of my reports, I get this error:
"An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Specified argument was out of the range of valid values. Parameter name:
date "
Does anyone have or heard of a solution?
Thank you!
What is your date format, MM/DD/YYYY or DD/MM/YYYY?|||Try installing SQL Server 2005 (and restore the databases on it) and run the reports.
Shyam
|||mm/dd/yyyy|||I cannot give up using SQL Server 2000 just because of this issue
|||I do not think you need to give up on SQL 2000 for this.
Can you share the script where you pass in the parameters?
|||<Value>=Globals!ReportName &" between " & Parameters!startdate.Value & " & " & Parameters!enddate.Value</Value>...
<ReportParameters>
<ReportParameter Name="startdate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=CDate(cstr(year(Now())) + "/" + "01" + "/" + "01" + " 00:00:01")</Value>
</Values>
</DefaultValue>
<Prompt>Start Date-Time (MM/DD/YYYY HH:MM:SS AM or PM)</Prompt>
</ReportParameter>
<ReportParameter Name="enddate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=CDate(cstr(year(Now())) + "/" + cstr(month(now())) + "/" + cstr(day(now())) + " 23:59:59")</Value>
</Values>
</DefaultValue>
<Prompt>End Date-Time (MM/DD/YYYY HH:MM:SS AM or PM)</Prompt>
</ReportParameter>
<ReportParameter Name="Team">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>%</Value>
</Values>
</DefaultValue>
<Prompt>Enter a Team with % as a wildcard character i.e. %Cust%</Prompt>
</ReportParameter>
</ReportParameters>|||
I do not see any problems in the script.
Please take a look at the server log and here's something for reference. If possible, please post what you can find from the log. HTH.
http://blogs.msdn.com/jgalla/archive/2006/12/05/diagnosing-rsinternalcatalogexception.aspx
|||Problem was resolved after power outage ;) and server restart.
|||Reboot is always the "best" solution for all MS issues.
