My Oracle Support Banner

Error: "Connection Has Been Recycled. Database $NAME Pool PMT" and CopyProject Service Fails When Attempting to Copy/Paste a Project in P6 (Doc ID 2152129.1)

Last updated on APRIL 18, 2018

Applies to:

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

Symptoms

When attempting to copy/paste a project, the "job" is failing with error:

ERROR
-----------------------
com.primavera.infr.db.ConnectionRecycledException: Connection has been recycled. Database $NAME Pool PMT
at com.primavera.infr.db.PConnection.a(Unknown Source)
at com.primavera.infr.db.PConnection.prepareStatement(Unknown Source)
at com.primavera.infr.db.PConnection.prepareStatement(Unknown Source)
at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
at com.primavera.bo.base.server.ServerDAOImpl.load(Unknown Source)
at com.primavera.bo.base.server.ServerDAOImpl.load(Unknown Source)
at com.primavera.dbcrudutil.CopyProjectJobService.a(Unknown Source)
at com.primavera.dbcrudutil.CopyProjectJobService.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)

[CopyProjectJobService] ERROR TIMESTAMP: DB Id: 1: Error while running Copy Project Service:Failed loading project in ###
[JobServiceExecutable] ERROR TIMESTAMP: DB Id: 1: Job error running job of type JT_CopyService on database1
com.primavera.PhoenixException: Failed loading project in ###

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into P6 Web
  2. Copy/Paste of a project -> job gets created
  3. View Service Status
  4. View "failed" log

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!


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