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-01 : 03:16:27
|
| I have 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 also 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. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-11-01 : 05:44:36
|
| on your Dataset in SSRS you can set the on your connection string under properties the "connect timeout".or you can always kill the process that is generated by Report Manager against your server and database in management console / activity monitor. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-01 : 15:56:45
|
| Okay - I have to ask...What good is a report of 'lakhs' of records? Who is going to be able to work that report and what good is having that much data in the report?Jeff |
|
|
|
schamp
Starting Member
13 Posts |
Posted - 2010-11-02 : 02:08:40
|
| The data is of transaction and daily there are thousands of transaction for one day date range. So if we think of 1 months date range then the records shoot upto lakhs of count.Its the client requirement to show the data for any date range. |
|
|
|
schamp
Starting Member
13 Posts |
Posted - 2010-11-02 : 07:01:40
|
| 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 Unavailable The 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 Timeout , Memory out of Exception