My Oracle Support Banner

Primavera Gateway Job Fails When Syncing to P6 With Error "Connection has been recycled. Database <NSTANCE NAME> Pool PMT" (Doc ID 2702143.1)

Last updated on AUGUST 18, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12 and later
Primavera Gateway - Version 19.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a P6 to P6 synchronization, the following error occurs.

ERROR
-----------------------
com.oracle.pgbu.pdi.provider.ProviderException: Connection has been recycled. Database XXX Pool PMT
at com.oracle.pgbu.pdi.p6provider.project.P6ProjectSaveStep.saveGlobalObjects(P6ProjectSaveStep.java:563)
at com.oracle.pgbu.pdi.p6provider.project.P6ProjectSaveStep.save(P6ProjectSaveStep.java:39)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveStep(JobSimulator.java:963)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveSideSteps(JobSimulator.java:821)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeCompare(JobSimulator.java:699)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSingleFlow(JobSimulator.java:461)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.execute(JobSimulator.java:401)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.run(JobSimulator.java:217)
at com.oracle.pgbu.framework.akka.jobs.ServiceExecutorWrapperActor.wrappedReceive(ServiceExecutorWrapperActor.java:36)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.processMessage(UntypedActorWithMetrics.java:39)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.onReceive(UntypedActorWithMetrics.java:33)
at akka.actor.UntypedAbstractActor$$anonfun$receive$1.applyOrElse(AbstractActor.scala:291)
at akka.actor.Actor$class.aroundReceive(Actor.scala:517)
at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:180)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:588)
at akka.actor.ActorCell.invoke(ActorCell.scala:557)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:258)
at akka.dispatch.Mailbox.run(Mailbox.scala:225)
at akka.dispatch.Mailbox.exec(Mailbox.scala:235)
at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

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
Cause
Solution
References


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