Cris Robin Absent Member.
Absent Member.
956 views

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.

0 Likes
6 Replies
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

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.

0 Likes
Outstanding Contributor.. Loc_Nguyen_PPM Outstanding Contributor..
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.”
0 Likes
Cris Robin Absent Member.
Absent Member.

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)

0 Likes
Cris Robin Absent Member.
Absent Member.

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

0 Likes
Outstanding Contributor.. Loc_Nguyen_PPM Outstanding Contributor..
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.”
0 Likes
Absent Member.. Jim Esler Absent Member..
Absent Member..

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.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.