Project and Portfolio Management Practitioners Forum
cancel

Cannot open connection

Highlighted
Cris Robin
Respected Contributor.

Cannot open connection

Hello

 

I am trying to connect to the platform like every other user.

But when I log in I get this "Cannot open connection".

 

any Ideas?

 

I am using ppm 7.1.0 SP8.

6 REPLIES
AlfredoMonasi
Honored Contributor.

Re: Cannot open connection

the IP is configured in the URL Base of the server.conf file?, otherwise you will have to modify your host file to relate the IP with the server name.

Loc_Nguyen_PPM
Outstanding Contributor.

Re: Cannot open connection

Hi Cris,

 

So it happend with only you or with all users ?

Did you see any error in server.conf file ?

 

Example: “No ManagedConnections available within configured blocking timeout” or “Cannot open connection”

 

Regards.

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Cris Robin
Respected Contributor.

Re: Cannot open connection

We disabled most of the users a week ago (it is a bank. and one week of the year no one can access the platform) but the admins users.

 

we also found out the if we use a link to a inner page it work perfectly. I can keep working on the requests and everything great untill I use the personal dashboards.

 

The errors in the systems are :

 

IST:    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:170)

JSESSIONID=BE3119BDA23EE029C2625BFB37CACAC7.kintana,USERNAME=D176435 server:http-0.0.0.0-8080-Processor25:SystemOut:2014/10/27-12:00:03.136 IST:    ... 80 more

JSESSIONID=BE3119BDA23EE029C2625BFB37CACAC7.kintana,USERNAME=D176435:http-0.0.0.0-8080-Processor25:org.hibernate.util.JDBCExceptionReporter:2014/10/27-12:00:03.138 IST: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Socket is not connected); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Socket is not connected))

JSESSIONID=BE3119BDA23EE029C2625BFB37CACAC7.kintana,USERNAME=D176435 server:http-0.0.0.0-8080-Processor25:SystemOut:2014/10/27-12:00:03.141 IST: org.hibernate.exception..GenericJDBCException: Cannot open connection

        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)

        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)

       at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:40)

        at $Proxy20.createStatement(Unknown Source)

        at com.mercury.dashboard.arch.db.DBUtils.getDBServerDate(DBUtils.java:467)

        at com.mercury.dashboard.arch.db.DateManager.getDBDateFromDB(DateManager.java:95)

        at com.mercury.dashboard.arch.db.DateManager.getDBServerDiff(DateManager.java:71)

        at com.mercury.dashboard.arch.web.util.UserDetails.<init>(UserDetails.java:158)

        at com.mercury.dashboard.arch.host.util.DashboardFilterServlet.service(DashboardFilterServlet.java:164)

        at javax.servlet.http.HttpServlet.service(HttpServlet..java:810)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)

        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

        at com.mercury.dashboard.arch.host.DashboardServlet.service(DashboardServlet.java:301)

        at javax.servlet.http.HttpServlet.service(HttpServlet..java:810)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:34)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:65)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:725)

        at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:50)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.mercury.dashboard.arch.host.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:63)

        at com.mercury.dashboard.arch.host.BaseFilter.doFilter(BaseFilter.java:48)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.kintana.core.web.filter.I18nFilter.applyFilter(I18nFilter.java:44)

        at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:43)

        at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.jboss.web.tomcat.security.CustomPrincipalValve..invoke(CustomPrincipalValve.java:66)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)

        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

        at java.lang.Thread.run(Thread.java:679)

Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Socket is not connected); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Socket is not connected))

        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:109)

        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)

        ... 73 more

Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Socket is not connected)

        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:178)

        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)

        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)

        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnecti

JSESSIONID=BE3119BDA23EE029C2625BFB37CACAC7.kintana,USERNAME=D176435 server:http-0.0.0.0-8080-Processor25:SystemOut:2014/10/27-12:00:03.144 IST: onPool.java:534)

        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:444)

        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:298)

        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)

        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)

        ... 75 more

Caused by: java.sql.SQLException: Io exception: Socket is not connected

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:170)

        ... 83 more

 

JSESSIONID=BE3119BDA23EE029C2625BFB37CACAC7.kintana,USERNAME=D176435:http-0.0.0.0-8080-Processor25:org.apache.jsp.arch.Error_jsp:2014/10/27-12:00:03.145 IST:

org.hibernate.exception.GenericJDBCException: Cannot open connection

        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)

        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)

        at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:40)

        at $Proxy20.createStatement(Unknown Source)

        at com.mercury.dashboard.arch.db.DBUtils.getDBServerDate(DBUtils.java:467)

        at com.mercury.dashboard.arch.db.DateManager.getDBDateFromDB(DateManager.java:95)

        at com.mercury.dashboard.arch.db.DateManager.getDBServerDiff(DateManager.java:71)

        at com.mercury.dashboard.arch.web.util.UserDetails.<init>(UserDetails.java:158)

        at com.mercury.dashboard.arch.host.util.DashboardFilterServlet.service(DashboardFilterServlet.java:164)

        at javax.servlet.http.HttpServlet.service(HttpServlet..java:810)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

Cris Robin
Respected Contributor.

Re: Cannot open connection

the link to the personal dashboard use parameter called assetid and give it the value -1.

I guess this is part of the problem (if -1 means that he doesn't got an ID)

 

Please addvice

Loc_Nguyen_PPM
Outstanding Contributor.

Re: Cannot open connection

Hi,

 

Please try with this

 

Change these values on your server.conf.  Seems like these parameters are using the default value.

MAX_DB_CONNECTION_IDLE_TIME=30  (default 60)
MAX_DB_CONNECTIONS=120                            (default 60)
MAX_DASHBOARD_DB_CONNECTIONS=100

After doing this we should manage the DB pool a lot better. I want to recommend that increase these parameters little by little, you need to check the performance each time you change the parameters

 

 

Hope this helps.

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Jim Esler
Acclaimed Contributor.

Re: Cannot open connection

I am not certain what you mean by disabling all users except admins, but the easiest way to do this is to use the setServerMode.sh script to put the application in RESTRICTED mode. Only admins can log in and everything operates normally for them.