Ok, thanks, we've been running these reports in CE or equivalent since v6, the data is there, it's either a configuration problem or a bug in CE 10, it returns the data in the viewer for a few users but when it is hit hard it stops responding, we are back on 8.5 until we resolve this and they...
Oracle via ODBC. The SQLs return almost immediately from CR or the dev environment. These reports have been running for years and are very simple, stored procs build the tables for the reports, all they do is read the output, it seems to be a # of concurrent request problem for on-demand in CE...
Thanks for your response. Nothing unusual in the logs. We applied all service packs and hotfixes, servers are numbered and configured according to the sizing docs, to no avail. Viewers come up blank after a few on-demand requests, no the 3000 is spread out over 24 hours, that is not excessive...
Found it on their site, thanks, we set it up with 3 job servers, 3 RAS servers, 2 page servers, 2 cache servers, and configured them as recommended, but it still fails after just 10 or 15 reports, the viewer comes up blank and we have to reboot, all job servers show up as running in the perf mon...
I have 10 now and they are all being used, so it still bogs down at times, is there a practical limit? Also what about the other servers, should I increase their numbers as well?
We get about 3000 report requests a day, managed/url.
Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.