CopyProject Service Fails With Error: "Connection Has Been Recycled"

(Doc ID 2152129.1)

Last updated on AUGUST 10, 2016

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:

 

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