SSRS Export to Excel is popular in our office but has been failing a lot recently- at the beginning of the year there were a few occurances a month until June, then they steadily increased until now it is nearly every time (44% of the events happened this
month.) Few software changes (just MS and virus def updates) No configuration changes until troubleshooting this issue began. Policy changes on both server and clients is possible as that is controled by contractors and we are not notified of changes.
Upon exploring I discovered export to tiff and web archive also fail, but csv, PDF, and xml seems to work most of the time. Some of the reports failing have not had any design changes in months. Reports are not particularly large- 2 to
4 tables with under 200 rows each. No more than 6 pages and then mostly because of page breaks between tables. no more than 5 levels of drill down- most have fewer than that. The failure happens very fast- about 4 seconds. If the data
is filtered down to very small sets so that the export process can complete inside those 4 seconds then it succeeds.
I have seem many questions on lots of forums with similar issues with SSRS but no solutions that worked for me. All the timeout values I know of (about 6?) are set to between 120 and 3600 seconds. None of my reports sh
View Complete Post