Error: "Could not get JDBC Connection; nested exception is java.sql.SQLException: Lease request timeout while waiting for connection to become available" When Running A Job Through P6 Services (Doc ID 1497061.1)

Last updated on JULY 14, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to publish a project, the following error occurs in the job log:

ERROR
-----------------------
Could not get JDBC Connection; nested exception is java.sql.SQLException: Lease request timeout while waiting for connection to become available. Database PMOPROD
DBEngine.executeStatement for failed:DBEngine.leaseConnection: Lease request timeout while waiting for a connection to become available. Database PMOPROD
.....
Resulting in a failed job status

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Browse to EPS view
2. Right-Click a project, and select Publish Project
3. Note the error which occurs

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms