search cancel

Process Automation - Error "Got minus one from read call" on log and PAM shutting down

book

Article ID: 190035

calendar_today

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.

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

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.