Skip to Content
0
Former Member
Jun 17, 2015 at 09:05 PM

Crystal Reports taking 10+ minutes to run

35 Views

Hello,

We are having an issue where several of our Crystal Reports are taking over 10 minutes to run and need to figure out why.

Platform: Windows Server 2008 R2, Quad 2.70 Xeon (VM), 16GB RAM

Database: Oracle 11gR2

Crystal Reports Server Embedded 2008 SP5

Some history: Our project went live in Feb '15 and things were good. We had 1 reporting server and reports would take a minute or 2 (if that). As time went on, the reports overwhelmed the Reporting Application Server 12 and had to be restarted multiple times per day. We scaled out the RAS service, installing it on all 4 application servers and that fixed our issue for a while. However, things are getting bad again, specifically with reports running longer than 10 minutes and intermittently not even completing.

Any suggestions would greatly be appreciated, please let me know if any further information is needed.

Thank You