June 12, 2020 at 5:41 pm
When I try to load gis esri .shp shape file on SSRS report server. I get error contact administror, not bale to load the file.
I am the administrator, I am able to load excel, pdf and Img files, but have no luck loading .shp file
June 12, 2020 at 6:04 pm
How large is the file? From what I remember (and a quick bit of googling), SSRS doesn't limit file types by default and I'm not even sure it supports limiting the file types you can upload.
That being said, it defaults to a 4 MB file size for uploads. My GUESS is that your shp file is more than 4 MB
this link explains how to fix this:
which states:
To resolve the issue, you can modify the Report Manager Web.config file usually located in C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER2\Reporting Services\ReportServer. Please keep in mind that the value you set for the maxRequestLength element must be larger than the actual size limits you want to enforce.
For example:
<httpRuntime maxRequestLength="100000" executionTimeout="9000" requestValidationMode="2.0" />
As this is SQL Server 2019, this link may also be helpful (is for 2016, but I expect it applies to 2019 as well):
basically shows you how to do it in the GUI, but says you MAY need to increase your MaxRequestSize
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply