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 laterInformation 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 |