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

Last updated on MARCH 30, 2017

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


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