Error "Unable to Get Permanent License" And/Or "java.sql.sqlrecoverableexception: IO Error: Connection Reset" Occur Randomly When Using Primavera Web Services (Doc ID 2464663.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Symptoms

When attempting to run an integration using Primavera Web Services, it randomly fails with errors like the following:

ERROR
-----------------------
com.primavera.PhoenixException: Unable to get permanent license
   Caused By: com.primavera.PhoenixException: An attempt to fetch a new NextKey for usession_session_id failed.
   Caused By: java.sql.SQLRecoverableException: IO Error: Connection reset
   Caused By: java.net.SocketException: Connection reset

java.sql.SQLRecoverableException: IO Error: Connection reset

ERROR com.primavera.bo.datacaches.ServerUserPrivsCache ?:? Failed loading user privilege information for user: 3504
com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {select prof_id, obs_id, user_id from userobs where user_id=?}[3504]
   Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset
   Caused by: java.net.SocketException: Connection reset
   Original Exception: java.sql.SQLRecoverableException: IO Error: Connection reset

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.