Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
schamp
Starting Member
13 Posts |
 Posted - 2010-11-02 : 07:18:01
|
| The .net code is executing the ssrs ".rdl" file from the ssrs report viewer.When the report viewer executes the ".rdl" report file below error is displayed.----------------------Server Application UnavailableThe web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.-----------------------SSRS 2005 report.The report displays 10,000 of records successfully, but when the report is supposed to display lakhs of records, the report gets time-out.I have tried the below changes but still the timeout occurs.1) In Report manager have selected the "Do not timeout report execution" option.2) In Machine.config changed the <processModel autoConfig="true" />to <processModel autoConfig="true" memoryLimit="120"/>3) In rsreportserver.config changed "MemoryLimit" and "MaximumMemoryLimit" to 120 and 160 respectively.I had also set the timeout=0 in the sql connection.How the timeout issue can be avoided? |
|
|
schamp
Starting Member
13 Posts |
Posted - 2010-11-25 : 07:02:44
|
| I am getting the below exception when I execute the report using report viewer."For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method." |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-25 : 07:09:42
|
| Check the memory usage - it's probably running out.I think in v2005 reporting services ahd to render in memory. v2008 it could use virtual memory.Why are you creting a report with hundreds of thousands of rows? No one is going to scroll through them.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SSRS 2005 Report Timeout , Memory out of Exception