Uri string is too long
I have an issue with running a report from BIDS. The report is fairly large with 6 parameters 2 of which have large > 3000 rows. When I select all values from each parameter, report in BIDS returns An error occured during local report processing Invalid URI: The Uri string is too long When I limit the amount of parameter values to minimum, report runs fine. I've found a couple of similar issue over the net and most were corresponding to timeout in BIDS. I've changed the timeout in BIDS and I still have the same error message. Thanks for any thoughts! Thomas Pollack
November 19th, 2012 1:23am

Hi, Please take a look on this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9868243f-61b2-4874-8356-991ef576cc3d I hope it will help. Regards Avanish T
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2012 1:59am

Thanks Avanish :) I found this tread and many others with similar error message however, none of those help me to resolve my problem.Thomas Pollack
November 19th, 2012 8:25pm

Hi Thomas, I have tried to reproduce the issue in my test environment, however, everything goes well. To narrow down whether the issue is related to the BIDS, I suggest that you check the issue with Report Builder and check the report after deploying it to a report server. Which version of SSRS are you using? If you use SSRS 2012, the issue may occur due to the check on the size limit by report processor. Please refer to the following blog: http://ppalakollu.blogspot.com.au/2012/06/sql-server-2012-reporting-services.html Hope this helps. Regards,Mike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2012 3:55am

Mike, thank you for your feedback and for the link! I didn't think about checking it in report builder. SSRS I'm using is 2008 R2 SP2 without latest CU. BIDS and Report Manager has a problem. In BIDS I receive the Uri error, in Report Manager; Message: 'length' is null or not an object. However, when the report is deployed and I run it via Report Builder, rendering is very slow but I can see the result with no errors. Would you have an idea how to continue troubleshooting from this point, Mike? Big thanks!!Thomas Pollack
November 20th, 2012 7:50pm

Hi Thomas, Thanks for your posting. It's a little odd that the report runs properly in Report Builder but fails in both BIDS and report manager. Could you post the detailed error message in the Reporting Services Log file that is located in the <Drive>:\Program Files\Microsoft SQL Server\MSRS10_50.<Instance Name>\Reporting Services\LogFiles folder? Regards,Mike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2012 5:55am

Thank you Mike :) I will make it more odd. When the same report is deployed to my local workstation Report Manager, it runs ok even thought in BIDS it returs Uri error. With that in mind I thought to check if I can run the report via Report Manager directly from SSRS server - No, I can't with the same error. Other client machines in my office have the same issue with running that report hence, it made me believe that it must be something to do with Report Services? Without copying the whole Reporting Services log, I replicated the problem and pasting only timeframe when the replication took place. Let me know if you need more info, Mike library!ReportServer_0-18!1150!11/23/2012-08:46:21:: Call to GetPermissionsAction(/Finance). library!ReportServer_0-18!1990!11/23/2012-08:46:21:: i INFO: Catalog SQL Server Edition = Enterprise library!ReportServer_0-18!1150!11/23/2012-08:46:21:: i INFO: Catalog SQL Server Edition = Enterprise library!ReportServer_0-18!1310!11/23/2012-08:46:21:: i INFO: Catalog SQL Server Edition = Enterprise crypto!ReportServer_0-18!1990!11/23/2012-08:46:21:: i INFO: Initializing crypto as user: ADM\adsqlmin crypto!ReportServer_0-18!1990!11/23/2012-08:46:21:: i INFO: Exporting public key crypto!ReportServer_0-18!1990!11/23/2012-08:46:21:: i INFO: Performing sku validation crypto!ReportServer_0-18!1990!11/23/2012-08:46:21:: i INFO: Importing existing encryption key library!ReportServer_0-18!dd4!11/23/2012-08:46:21:: Call to GetPropertiesAction(/, PathBased). library!ReportServer_0-18!1990!11/23/2012-08:46:21:: Call to GetPropertiesAction(/Finance, PathBased). library!ReportServer_0-18!1310!11/23/2012-08:46:21:: Call to GetPropertiesAction(/, PathBased). library!ReportServer_0-18!1990!11/23/2012-08:46:22:: Call to GetPropertiesAction(/Finance, PathBased). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to GetPropertiesAction(/, PathBased). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to GetPropertiesAction(/, PathBased). library!ReportServer_0-18!dd4!11/23/2012-08:46:22:: Call to GetSystemPermissionsAction(). library!ReportServer_0-18!1310!11/23/2012-08:46:22:: Call to GetSystemPermissionsAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to GetSystemPermissionsAction(). library!ReportServer_0-18!dd4!11/23/2012-08:46:22:: Call to ListChildrenAction(/, False). library!ReportServer_0-18!1310!11/23/2012-08:46:22:: Call to ListChildrenAction(/Finance, False). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to ListChildrenAction(/, False). library!ReportServer_0-18!1310!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!96c!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!11bc!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!dd4!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!11bc!11/23/2012-08:46:22:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:24:: Call to GetPermissionsAction(/Finance). library!ReportServer_0-18!1150!11/23/2012-08:46:24:: Call to GetPropertiesAction(/Finance, PathBased). library!ReportServer_0-18!17e4!11/23/2012-08:46:24:: Call to GetPropertiesAction(/Finance, PathBased). library!ReportServer_0-18!17e4!11/23/2012-08:46:24:: Call to GetSystemPermissionsAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:24:: Call to ListChildrenAction(/Finance, False). library!ReportServer_0-18!1150!11/23/2012-08:46:24:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!17e4!11/23/2012-08:46:24:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:24:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1150!11/23/2012-08:46:24:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1384!11/23/2012-08:46:42:: Call to GetPermissionsAction(/Finance/Finance Complete). library!ReportServer_0-18!1310!11/23/2012-08:46:42:: Call to GetSystemPropertiesAction(). library!ReportServer_0-18!1310!11/23/2012-08:46:42:: Call to GetPropertiesAction(/Finance/Finance Complete, PathBased). library!ReportServer_0-18!1384!11/23/2012-08:46:43:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-17!dd4!11/23/2012-08:46:43:: i INFO: PageCountMode 'Estimate' read from config file ui!ReportManager_0-17!dd4!11/23/2012-08:46:43:: i INFO: AccessibleTablix value not specified in config file. library!ReportServer_0-18!1310!11/23/2012-08:46:44:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:28:: e ERROR: System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!1990!11/23/2012-08:47:28:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:28:: e ERROR: HTTP status code --> 500 -------Details-------- System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!dd4!11/23/2012-08:47:28:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:28:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) ui!ReportManager_0-17!dd4!11/23/2012-08:47:29:: e ERROR: System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!1990!11/23/2012-08:47:29:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-17!dd4!11/23/2012-08:47:29:: e ERROR: HTTP status code --> 500 -------Details-------- System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!1150!11/23/2012-08:47:29:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-17!dd4!11/23/2012-08:47:29:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) ui!ReportManager_0-17!1150!11/23/2012-08:47:32:: e ERROR: System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!dd4!11/23/2012-08:47:32:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:32:: e ERROR: HTTP status code --> 500 -------Details-------- System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!dd4!11/23/2012-08:47:32:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:32:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) ui!ReportManager_0-17!1150!11/23/2012-08:47:44:: e ERROR: System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!17e4!11/23/2012-08:47:44:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:44:: e ERROR: HTTP status code --> 500 -------Details-------- System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!1384!11/23/2012-08:47:44:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-17!1150!11/23/2012-08:47:44:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) ui!ReportManager_0-17!1150!11/23/2012-08:48:11:: e ERROR: System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!dd4!11/23/2012-08:48:11:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-17!1150!11/23/2012-08:48:11:: e ERROR: HTTP status code --> 500 -------Details-------- System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() --- End of inner exception stack trace --- at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-18!1990!11/23/2012-08:48:11:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-17!1150!11/23/2012-08:48:11:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) Thomas Pollack
November 22nd, 2012 7:56pm

Hi Mike, I took a moment to actually look more carefully at the log after posting. I researched "ERROR: System.Web.HttpException: The URL-encoded form data is not valid.". It came out to be a fault in Security Update restricting MaxHttpCollectionKeys (KB2656355, KB2656356) I've changed Report Manager web.config. I added <add key="aspnet:MaxHttpCollectionKeys" value="10000" /> in AppSettings and it has resolved the problem. I''m posting resolution for others if they will experience a similar issue. Thomas Pollack
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2012 8:47pm

Hi Thomas, I am glad to hear that you have resolved the issue by yourself. Yes, the error details indicate that the root cause is that Microsoft security update MS11-100 limits the maximum number of form keys, files, and JSON members to 1000 in an HTTP request. Thanks for your useful sharing. Hope more community members who face with the same issue can benefit from this thread. Regards,Mike Yin TechNet Community Support
November 22nd, 2012 9:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics