Error: "Connection has been recycled. Database $DatabaseName Pool PML" Saving Scenario in Portfolio View of P6 Web (Doc ID 2137276.1)

Last updated on MAY 19, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 8.3.12.0 [Release 8.3]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.3 to 8.3.12.0 [Release 8.3]
Information in this document applies to any platform.

Symptoms

When attempting to save a scenario for a portfolio, the save operation takes a long time to run and eventually fails with the following error:

ERROR
-----------------------
com.primavera.PhoenixException: Connection has been recycled. Database $DatabaseName Pool PML
at com.primavera.bo.base.LDBEngineImpl.commitTransaction(Unknown Source)
at com.primavera.bo.rules.create.CreateScenarioEngine.c(Unknown Source)
at com.primavera.bo.rules.create.CreateScenarioEngine.create(Unknown Source)
at com.primavera.bo.base.server.ServerDAOImpl.create(Unknown Source)
at com.primavera.bo.remotable.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.remotable.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.remotable.qproxy.ReqMgr.createObjectWithWbsContext(Unknown Source)

Note, The portfolio contains 8 projects with more than 5000 activities. Portfolios with fewer projects and activities seem to work.


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

  1. Login to P6.
  2. Navigate to the Portfolios Tab.
  3. Save a very large scenario as a Portfolio.

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