.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS 2008 ERROR - rsProcessingAborted:System.ArgumentOutOfRangeException: Index was out of range. Mu

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server


I am using SQL Server 2008 R2 Ent. Edition 64 bit reporting services. The source data for report is at remote server and it is SQL Server 2005 Ent. Edition (though I don't think this matters here.) I have set the <WorkingSetMaximum> to 5GB for SSRS

I am testing the performance of report server and running a report with 100K records with 20 concurrent users. All 20 reports gets executed successfully. When I try with 25 or 30 users only 21 reports execute successfully when I see the ExecutionLog table. I see this exception in the report service log file. Please help.

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.RemoveReadOnlyMembers(List`1 declarations)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader..cto

View Complete Post

More Related Resource Links

StringBuilder.ToString() Throws a System.ArgumentOutOfRangeException Index was out of range


I have the following code to show a logging window that has the last 64000 chars of code. Every new line I add the first line will be deleted:

m_sbText = new StringBuilder(65000);

private void AddLine(string LogMessage)
   if (m_sbText.Length > 64000)
      m_sbText.Remove(0, m_sbText.ToString().IndexOf("\n") + 1);
   textBoxLog.Text = m_sbText.ToString();

When I let this run the first time I got an OutOfMemory exception because I forgot to add

textBoxLog.UndoLimit = 0;

So this UndoLimit problem is still happening in WPF dot net framework 4. 

I added the UndoLimit and let this run for a night. Once every few hours the textBoxLog.Text = m_sbText.ToString(); line raises a System.ArgumentOutOfRangeException Index was out of range exception on StringBuilder.ToString(). Because I do not do anything with the Index I suspect the StringBuilder to mess up internal indexes.

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Parameter is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:   [Exception: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

Range bar chart having multi-color bars + SSRS 2008

Hi, I want to display 2 different colrs on the same bar in range bar chart. My chart is displaying project risks (MS project kind of chart). Each risk has its own start date, end date. In case of dependent risks, the start date of dependent risk becomes the end date of the risk on which it depends. Each risk has 2 parts. Lost opportunity & Remaining opportunity. I want to display Lost in red & remaining in Green. Can I display 2 different colors on the same bar? Regards, Neeraj

"Service not available " Error in SSRS 2008

HI ALL, I Have created few reports in SSRS 2008 and deployed to report manager,though reports are working fine in it but sometime what happens when we click any reports its shows error "Service UnAvailable". after getting that report ,i simply close the window and open again after 10 or so ,again it work fine . Please suggest whether its a bug in report manager or i am commited some mistakes over it.   Regards Amit.

How to create Range bar chart i n SSRS 2008

  Hi How to create Range bar chart i n SSRS 2008 amit

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Package Migration Wizard error -- Index was out of range

I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions?"Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index (mscorlib) ------------------------------Program Location:    at System.Collections.ArrayList.get_Item(Int32 index)   at WizardUI.ListPackages.UniquePackagewithCurrentVersion(PackageInfoCollection m_pInfoCol)   at WizardUI.ListPackages.OnEnterPage(EventArgs e)   at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()   at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)   at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)"

SSRS 2008 error - Sys.WebForms.PageRequestManagerServerErrorException: status code 12029



I am executing a huge report in SSRS 2008, after some time the report doesn't renders and there is an error icon at the left bottom of the web page. When I click open it to see the details, it gives following error;

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while
processing the request on the server. The status code returned from the server was: 12029.

Any help on this will be appreciated.


SSRS 2008 R2 Email error


I'm attempting to ude the email notification through a subscription in SSRS 2008 R2 but am getting the following error:

An error has occurred during report processing.

The logs say:

library!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: An exception has occurred in data set 'ComponentList'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
processing!WindowsService_19!720!09/24/2010-10:10:25:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingS

Error SSRS 2008


I would like to save a Report as PDF.

It says an error; Invalide URI: The hostname couldnt be parsed.


What does that mean? It works on the others.



One who can read, have a clear advantage!

Sharepoint & SSRS 2008 "System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft


my environment as below:

1- SERVER A (SQL server DB 2008 sp1)
2- Server A (SSRS 2008 sp)
3- SERVER B MOSS 2007 sp1
I configured the SSRS to be sharepoint intergated mode but when i  hit the Web Service URL i got the error below:

Reporting Services Error

  • The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled)

    SSRS 2008 R2 error


    I wrote a custom function in a ssrs 2008 r2 report and tried to reference it in an experssion on a parameter, but I keep getting this error message "the defaultvalue exprsssion for thre report parameter "parm1" contains an error: Request for the permission of type 'Sytem.Security.Permissions.UIPermission, mscorlib, Version=, Culture=neutral, PublicKey Token=b77a5c561934e089' failed."

    My expression looks like this:  =Code.functioname(value1, value2)

    I there  a security setting I need to make to get this to work?


    Thanks in advance.




ssrs 2008 reports Datasource error in Test server..


Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.


Why? Can anyone give me some idea...?


Word Export error when orientation is Landscape in SSRS 2008


Hi there,

        I have created a report in SSRS 2008, In the report properties I have selected Orientation as Landscape but when i Export the report to Word it prints the report on middle of the page and cuts the rest of the report.

Urgent help is needed!!!

error index out of range?



I get the error:

Index was out of range. Must be non-negative and less than the size of the collection.

when vieing a page with a datalist on it. i have other controls in the datalist. what would cause this? here is my code behind Thanks!:

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
        Label theiruseridLabel = DataList1.Items[0].FindControl("theiruseridLabel") as Label;
        HyperLink hp2 = DataList1.Items[0].FindControl("HyperLink2") as HyperLink;
        HyperLink hp3 = DataList1.Items[0].FindControl("HyperLink3") as HyperLink;
        Label Label1 = DataList1.Items[0].FindControl("Label1") as Label;

        string userName = theiruseridLabel.Text;
        ProfileCommon userProfile = System.Web.Profile.ProfileBase.Create(userName, true) as ProfileCommon;
        hp2.Text = userProfile.FirstName;

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend