Process Automation - Error "Got minus one from read call" on log and PAM shutting down
Article ID: 190035
Updated On:
Products
Process Automation Manager
CA Process Automation Base
Issue/Introduction
During time to time, PAM stops by itself and the log show the following messages:
Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 11 ms., Authentication lapse 0 ms.
Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 11 ms., Authentication lapse 0 ms.
Environment
Process Automation - All Versions
Cause
Reviewing the logs, the following messages can be seen:
WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] [_autoTPRecovery] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 11 ms., Authentication lapse 0 ms.)
WARN [org.hibernate.util.JDBCExceptionReporter] [_autoTPRecovery] SQL Error: 0, SQLState: null
ERROR [org.hibernate.util.JDBCExceptionReporter] [_autoTPRecovery] Unable to get managed connection for OptinuityDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for OptinuityDS)
ERROR [com.optinuity.c2o.persistence.DatabaseManager] [_autoTPRecovery] Unable to load orchestrator with ID -> 7b6c9b91-4992-4be2-bc8f-12e923650768
org.hibernate.exception.GenericJDBCException: Cannot open connection
This error is generated by the DBMS (on this case, Oracle) and it means that PAM is requesting the availability to open new connections against the database, but the DBMS is not doing it.
Here is this error discussed on Oracle's forums:
IO Error: Got minus one from a read call
WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] [_autoTPRecovery] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 11 ms., Authentication lapse 0 ms.)
WARN [org.hibernate.util.JDBCExceptionReporter] [_autoTPRecovery] SQL Error: 0, SQLState: null
ERROR [org.hibernate.util.JDBCExceptionReporter] [_autoTPRecovery] Unable to get managed connection for OptinuityDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for OptinuityDS)
ERROR [com.optinuity.c2o.persistence.DatabaseManager] [_autoTPRecovery] Unable to load orchestrator with ID -> 7b6c9b91-4992-4be2-bc8f-12e923650768
org.hibernate.exception.GenericJDBCException: Cannot open connection
This error is generated by the DBMS (on this case, Oracle) and it means that PAM is requesting the availability to open new connections against the database, but the DBMS is not doing it.
Here is this error discussed on Oracle's forums:
IO Error: Got minus one from a read call
Resolution
In order to solve this issue, Oracle's DBA must increase the number of allowed maximum connections on PAM's database.
Additional Information
When PAM is configured to use Oracle as database, there are some manual configurations that must be set before running the installer:
Prepare an Oracle Database
Among them is the number of maximum allowed connections, that the DBA must increase if PAM requires more, based on actual use and work load.
Prepare an Oracle Database
Among them is the number of maximum allowed connections, that the DBA must increase if PAM requires more, based on actual use and work load.
Feedback
Yes
No
Powered by
