Publication Jobs Stuck in Pending Status With Error: "Connection has been recycled. Database <databasename> Pool PML"

(Doc ID 2418707.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms

The following error occurs when running P6 Services (project publication):

ERROR FOUND IN P6WebAccess.html

com.primavera.summarizer.SummarizerException: Problem summarizing SummaryTaskSpread data
  Caused by: com.primavera.summarizer.SummarizerException: BusinessObject.setStmtParam()
  Caused by: com.primavera.PhoenixException: BusinessObject.setStmtParam()
  Caused by: com.primavera.infr.db.ConnectionRecycledException: Connection has been recycled. Database <databasename> Pool PML

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, the publication jobs are not completing successfully.

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