DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, August 2, 2016

REP-56055 exceeded max connections allowed Oracle Reports Erro

ERROR:

REP-56055 exceeded max connections allowed Oracle Reports Error


SOLUTION:

1. Find the file $DOMAIN_HOME/reports/conf/repservername.conf

where $DOMAIN_HOME is your applications (not infrastructure) home, and repservername is your reports server name, i.e. rep_markr.
2. Find the line <connection maxConnect="20" idleTimeOut="15">
3. Change the maxConnect value to something like "100"
4. Restart your reports server, i.e.

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS

2 comments:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

Raj M said...

Hi,
I got below solution in the forums.
what's the purpose of this parameter - engineResponseTimeOut ? I'm not clear.

===============================================

Two changes recommended to solve this situation, how to implement these two steps differ from 10gR2- and 11gR1+ versions.

1. Increase maxConnect parameter for the in Reports Server.

2. Add engineResponseTimeOut to Reports Server



Please see the specific steps below for various versions.



For 11g and later, use the following steps :

1. Go to Enterprise Manager (aka FMW Control)

2. Click on the Report Server under "Reports" node.

3. Open "Advanced Configuration" page (Reports --> Administration --> Advanced Configuration). Both the maxConnect (Maximum Connections) and engineResponseTimeOut (Engine Reponse Timeout (min) ) parameters can be configured from this page.
=============================================