Crystal Reports taking 10+ minutes to run

[Former Member]

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

[former_member11696]

Hi Ben,

Please log a case in Service Market Place and we'll drill into the issue.

https://support.sap.com

Have a look at these KBA's also:

1370542 Simplified configuration for Crystal Reports Server Embedded 2008 Round Robin usage

1385446 Crystal Reports Server Embedded 2008 Sizing & Configuration Guide for OEM Partners

Only can be searched for in SMP

Thanks

Don