"(rsInternalError) Index was outside the bounds of the array" after upgrade to SRS SP2

After upgrading to SQL Reporting Services SP2, we now get an error every time we try to run any of our reports. The error is

"An unexpected error occurred in Report Processing. (rsInternalError) Index was outside the bounds of the array."

Anyone have any suggestions?

I looked in the Report Server logs and see this error but there is no other information that points me to the problem.
Thanks in advance.

[415 byte] By [Chrisk23] at [2008-3-7]

«« Mobile (Pocket PC) and MaskedTextBox
»» Date matching

# 1

Try to restart IIS.
Also, are there any errros in th report server log files?

-Lukasz

LukaszPawlowski at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

I also faced the same problem, might be a bug in MSSRS, IIS reset didn't helped, but when I deployed the report, it worked...Strange!!!

-Ajit

AjitGodbharle at 2007-9-8 >

# 3

Were there any errors in the report server log files?

-Lukasz

LukaszPawlowski at 2007-9-8 >

# 4

I am getting the same problem! The reports work on my Dev server, buty when I move the database and keys to the Prod machine I get the error. Restarting IIS doesn't help and I also get an error when I try to deploy reports to the Prod.

Any Ideas?

PeterG_75 at 2007-9-8 >

# 5

Same problem for me. In this case i took an existing report, which still works, and added some extra columns. Now i get the "Index out of bounds error". Rather unhelpful error message...

Looked in report server logs but nothing in there that relates as far as i can tell.

Zephyr12345 at 2007-9-8 >

# 6

OK, here is one fix. The Index error exception popped up when i entered the parameters and hit "View Report". Now recall I had changed the fields being included in the report. Apparently the report caches these columns in Preview mode. I hit the Refresh button in the Preview mode and the report magically appeared. Now clicking View Report works also.

Zephyr12345 at 2007-9-8 >

# 7

Can you submit your error log from the file reportserverservice<date>.log in the LogFiles folder under your Reporting Services installation path?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

LukaszPawlowski--MS at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech