My Oracle Support Banner

Summarize and Apply Actuals Max the Data Pool and Deny Connections (Doc ID 2054233.1)

Last updated on MARCH 06, 2019

Applies to:

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

Symptoms

When attempting to run Summary Jobs or Apply Actual Jobs, errors similar to the below may occur.

ERROR
-----------------------

Jul-24-2015 08:09:34 163 PrmThread-43 ERROR com.primavera.summarizer.Summarizer ?:? logs.summarizer.failedJobInfo [m_jobId=3501694, m_jobName=WEB1437746694, m_jobType=JT_Sum, m_lastRunDate=null, m_nextStart=null, m_recurType=RT_WebASAP, m_sequenceNum=1342804, m_status=JS_Pending, m_updateDate=2015-07-24 08:04:58.0, m_userId=3497, m_workerHost=null]
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Lease request timeout while waiting 30 seconds for a connection to become available. Database TEMP.aac.va.gov, Pool=PML
  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
  at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
  at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
  at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
  at com.primavera.summarizer.dao.SummarizerDAO.deleteProjIdFromTempTable(Unknown Source)
  at com.primavera.summarizer.Summarizer.a(Unknown Source)
  at com.primavera.summarizer.Summarizer.runJob(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.c(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.a(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.execute(Unknown Source)
  at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
  at java.lang.Thread.run(Thread.java:745)
  Caused by: java.sql.SQLException: Lease request timeout while waiting 30 seconds for a connection to become available. Database TEMP.aac.va.gov, Pool=PML
  at com.primavera.infr.db.SQLConnectionPool.getConnection(Unknown Source)
  at com.primavera.infr.db.SQLConnectionPool.getConnection(Unknown Source)
  at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
  ... 12 more
  Caused by: com.primavera.common.exceptions.LeaseRequestWaitTimeoutException: Lease request timeout while waiting 30 seconds for a connection to become available. Database TEMP.aac.va.gov, Pool=PML
  at com.primavera.infr.db.SQLConnectionPool.d(Unknown Source)
  ... 16 more


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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