topic Re: RDL file size limit for Report Server in Report Server

RDL file size limit for Report Server

Anonymous — Thu, 06 May 2021 23:20:51 GMT

This is specific for PowerBI Report server

I have a RDL file size about 1.5 MB.

when review few columns from the table tablix to reduce the size. I have no issue to deploy the report.

but once the file size over 1.5MB.

below error when trying to deploy

Severity Code Description Project File Line Suppression State
Error System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded.
at System.Web.HttpRequest.GetEntireRawContent()
at System.Web.HttpRequest.get_InputStream()
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) 0

for older version Report server usually adding a config maxRequestLength will work

Any suggestion for the latest version PowerBI report server

Re: RDL file size limit for Report Server

AbhiSSRS — Fri, 07 May 2021 09:25:33 GMT

Please try to upload large files directly to ReportServer from portal.

For deployment issue :

You may serach for Timeout property in config on powerBireport server and set that. Its same as legacy report server in web.config

set it to below (the maxrequestlength is in KB and max value can be set to Max value of integer 2147483647

Apart from this you may set below to higher value in RSReportServer.config for reports that run longer :

Please mark as solution if this helps!

Thanks!
Abhinav

Re: RDL file size limit for Report Server

Anonymous — Sat, 08 May 2021 06:15:57 GMT

Not working, seems there are some error and I got a dump file with error log

what will be the step to troubleshoot?

Re: RDL file size limit for Report Server

AbhiSSRS — Tue, 11 May 2021 07:04:31 GMT

Hi!

Please make the change only in web.config and check Like I have below length set up and it works well.

Re: RDL file size limit for Report Server

Anonymous — Tue, 11 May 2021 17:55:32 GMT

Hello, follow instruction and it is not working for me

Updated web.config and restart service

Upload 4mb xml file get this error

RSPortal_2021_05_11_10_47_37

see below error :

2021-05-11 10:49:18.1154|INFO|10|Received request PUT /api/v2.0/catalogitems(a974dde6-a84b-4794-8f0c-4ab21c7285ba)| RequestID = s_c9ed1c27-b711-462f-9ef9-3c9c83bb472f
2021-05-11 10:49:29.9746|ERROR|10|OData exception occurred: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetItemDefinition(String itemPath, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.UpdateReport(IPrincipal userPrincipal, String origItemPath, Report item, Boolean renameOrMove, String[] delta)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.Update(IPrincipal userPrincipal, String origItemPath, CatalogItem catalogItem, String[] delta)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.PutEntity(String key, CatalogItem entity)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Put(ODataPath oDataPath, T value)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext().| RequestID = s_c9ed1c27-b711-462f-9ef9-3c9c83bb472f

Re: RDL file size limit for Report Server

Anonymous — Thu, 27 May 2021 21:04:28 GMT

This is not resolve yet.
Any suggestion about the error?

Re: RDL file size limit for Report Server

varadharajan — Tue, 09 Apr 2024 17:38:48 GMT

if u got any solution for above mentioned issue ,yes meants can u share the solution pls

Re: RDL file size limit for Report Server

varadharajan — Tue, 09 Apr 2024 17:40:00 GMT

have any solution pls