Summarize and Apply Actuals Max the Data Pool and Deny Connections

Last updated on MARCH 30, 2017

Applies to:

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