on 10-28-2004 10:21 AM
During a Http request load test on my portal I got the following response:
/*** RESPONSE START ***/
com.sapportals.portal.prt.runtime.PortalRuntimeException: Exception in connection
at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:270)
at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:532)
at java.security.AccessController.doPrivileged(Native Method)
at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.inqmy.services.servlets_jsp.server.InvokerServlet.service(InvokerServlet.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.inqmy.services.servlets_jsp.server.RunServlet.runSerlvet(RunServlet.java:147)
at com.inqmy.services.servlets_jsp.server.ServletsAndJspImpl.startServlet(ServletsAndJspImpl.java:789)
at com.inqmy.services.httpserver.server.RequestAnalizer.checkFilename(RequestAnalizer.java:644)
at com.inqmy.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:305)
at com.inqmy.services.httpserver.server.Response.handle(Response.java:166)
at com.inqmy.services.httpserver.server.HttpServerFrame.request(HttpServerFrame.java:1152)
at com.inqmy.core.service.context.container.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:36)
at com.inqmy.core.cluster.impl0.ParserRunner.run(ParserRunner.java:35)
at com.inqmy.core.thread.impl0.ActionObject.run(ActionObject.java:46)
at java.security.AccessController.doPrivileged(Native Method)
at com.inqmy.core.thread.impl0.SingleThread.run(SingleThread.java:132)
Caused by: com.sap.security.api.UMRuntimeException: ORA-00020: maximum number of processes (80) exceeded
at com.sap.security.core.persistence.datasource.imp.J2EEConnectionPool.getConnection(J2EEConnectionPool.java:201)
at com.sap.security.core.persistence.datasource.imp.DataBasePersistence.beginTransaction(DataBasePersistence.java:1924)
at com.sap.security.core.persistence.imp.DistributedTransaction.commit(DistributedTransaction.java:224)
at com.sap.security.core.imp.AbstractUserAccount.commit(AbstractUserAccount.java:1875)
at com.sap.security.core.logon.imp.JUMAuthenticator.logon(JUMAuthenticator.java:946)
at com.sapportals.portal.prt.service.authenticationservice.AuthenticationService.login(AuthenticationService.java:298)
at com.sapportals.portal.prt.connection.UMHandler.handleUM(UMHandler.java:115)
at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:166)
at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:532)
at java.security.AccessController.doPrivileged(Native Method)
at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.inqmy.services.servlets_jsp.server.InvokerServlet.service(InvokerServlet.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.inqmy.services.servlets_jsp.server.RunServlet.runSerlvet(RunServlet.java:147)
at com.inqmy.services.servlets_jsp.server.ServletsAndJspImpl.startServlet(ServletsAndJspImpl.java:789)
at com.inqmy.services.httpserver.server.RequestAnalizer.checkFilename(RequestAnalizer.java:644)
at com.inqmy.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:305)
at com.inqmy.services.httpserver.server.Response.handle(Response.java:166)
at com.inqmy.services.httpserver.server.HttpServerFrame.request(HttpServerFrame.java:1152)
at com.inqmy.core.service.context.container.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:36)
at com.inqmy.core.cluster.impl0.ParserRunner.run(ParserRunner.java:35)
at com.inqmy.core.thread.impl0.ActionObject.run(ActionObject.java:46)
at java.security.AccessController.doPrivileged(Native Method)
at com.inqmy.core.thread.impl0.SingleThread.run(SingleThread.java:132)
Nested Exception:
java.sql.SQLException: ORA-00020: maximum number of processes (80) exceeded
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:360)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
at com.inqmy.services.dbpool.ConnectionPoolDataSourceImpl.getPooledConnection(ConnectionPoolDataSourceImpl.java:146)
at com.inqmy.services.dbpool.ConnectionStorage.getPhysicalConnection(ConnectionStorage.java:337)
at com.inqmy.services.dbpool.ConnectionStorage.getWriteLockConnection(ConnectionStorage.java:399)
at com.inqmy.services.dbpool.QConnection.beforeOperation(QConnection.java:44)
at com.inqmy.services.dbpool.XAQConnection.beforeOperation(XAQConnection.java:112)
at com.inqmy.services.dbpool.XAQConnection.getAutoCommit(XAQConnection.java:139)
at com.sap.security.core.persistence.datasource.imp.J2EEConnectionPool.getConnection(J2EEConnectionPool.java:194)
at com.sap.security.core.persistence.datasource.imp.DataBasePersistence.beginTransaction(DataBasePersistence.java:1924)
at com.sap.security.core.persistence.imp.DistributedTransaction.commit(DistributedTransaction.java:224)
at com.sap.security.core.imp.AbstractUserAccount.commit(AbstractUserAccount.java:1875)
at com.sap.security.core.logon.imp.JUMAuthenticator.logon(JUMAuthenticator.java:946)
at com.sapportals.portal.prt.service.authenticationservice.AuthenticationService.login(AuthenticationService.java:298)
at com.sapportals.portal.prt.connection.UMHandler.handleUM(UMHandler.java:115)
at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:166)
at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:532)
at java.security.AccessController.doPrivileged(Native Method)
at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.inqmy.services.servlets_jsp.server.InvokerServlet.service(InvokerServlet.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.inqmy.services.servlets_jsp.server.RunServlet.runSerlvet(RunServlet.java:147)
at com.inqmy.services.servlets_jsp.server.ServletsAndJspImpl.startServlet(ServletsAndJspImpl.java:789)
at com.inqmy.services.httpserver.server.RequestAnalizer.checkFilename(RequestAnalizer.java:644)
at com.inqmy.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:305)
at com.inqmy.services.httpserver.server.Response.handle(Response.java:166)
at com.inqmy.services.httpserver.server.HttpServerFrame.request(HttpServerFrame.java:1152)
at com.inqmy.core.service.context.container.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:36)
at com.inqmy.core.cluster.impl0.ParserRunner.run(ParserRunner.java:35)
at com.inqmy.core.thread.impl0.ActionObject.run(ActionObject.java:46)
at java.security.AccessController.doPrivileged(Native Method)
at com.inqmy.core.thread.impl0.SingleThread.run(SingleThread.java:132)
/*** RESPONSE END ***/
Anybody who has an idea what the problem could be? More importantly, how can I solve the problem?
THANK YOU!
No solution found.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ORA-00020: maximum number of processes (%s) exceeded
Cause: All process state objects are in use.
Action: Increase the value of the PROCESSES initialization parameter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
By the way, my load test was a minor one, i.e. 10 threads / 10 loops / 0 ramp-up time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
8 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.