Dealing with “REP-56055: Exceed max connections allowed: 20″ Oracle Reports Error
July 23rd, 2003 by Mark Rittman
If you’re using Oracle Reports delivered as either a JSP or through the Reports Servlet, and you’re getting the error “REP-56055: Exceed max connections allowed: 20″, you need to increase the maxConnect value in the reports configuration file to a higher value.
- Find the file $ORACLE_HOME/reports/conf/repservername.conf
where $ORACLE_HOME is your applications (not infrastructure) home, and repservername is your reports server name, i.e. rep_markr.
- Find the line <connection maxConnect=”20″ idleTimeOut=”15″>
- Change the maxConnect value to something like “100″
- Restart your reports server, i.e.
$ORACLE_HOME/dcm/bin/dcmctl restart -co OC4J_BI_Forms -v
which fixed the error for me.
May 6th, 2004 at 6:57 pm
I have OracleAS Forms and Reports Services v9.0.4
i increase the maxConnect=”20″ to 150 and after one day have this one :
REP-56055: Exceed max connections allowed: 150
Can you help me
July 2nd, 2004 at 4:26 pm
How many clients are connecting to server *at the same time* ? (ie how many simultaneous requests ?)
greater than 150 ?
This error means just that.
So you need to set this value according to requests you are expecting.
May 15th, 2007 at 12:47 pm
Hello Mr. Rittman
Can you help me please: a report is called from forms 9i with web.show_document (…, ‘_blank’);
due to Citrix it is impossible to open a new browser window
(this problem must be solved on the user’s side).
My problem is, that maxConnect-number grows up to 400 and the message REP-56055 comes everywhere.
How can I catch it? (=if the report not showed, no connection)
Thank you in advance.
S.Pilhofer
September 19th, 2007 at 10:15 am
Hello, Mr. Rittman / PIlhofer.
Have you solved?. We have the same problem. With 100, 200, 300… the message comes everywhere.
Thanks.