Error: "An attempt to fetch a new NextKey for sumtrsrc_sumtrsrc_id failed" And "Error while persisting assignment summary rollups for project XX and wbs ids" When Trying to Summarize a Project (Doc ID 1537706.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Symptoms

When attempting to summarize projects through P6 Windows or P6 Web Access the job process fails and logs the following errors:

ERROR

EXCEPTION: com.primavera.summarizer.SummarizerException:Failed calculating field rollups for project XX and wbs ids [XX]

OR

EXCEPTION: com.primavera.summarizer.SummarizerException:Error while persisting assignment summary rollups for project XX and wbs ids = [XX]

OR

ERROR com.primavera.infr.srvcs.NextKeyServiceImpl ?:? An attempt to fetch a new NextKey for sumtrsrc_sumtrsrc_id failed.
com.primavera.PhoenixException: An attempt to fetch a new NextKey for sumtrsrc_sumtrsrc_id failed.
at com.primavera.infr.srvcs.NextKeyServiceImpl.a(Unknown Source)
at com.primavera.infr.srvcs.NextKeyServiceImpl.getNextKey(Unknown Source)
at com.primavera.bre.SubSystemFacadeImpl.getNextKey(Unknown Source)
at com.primavera.bo.base.EngineUtils.doGetNextKey(Unknown Source)
at com.primavera.bo.base.EngineUtils.getNewObjectId(Unknown Source)
at com.primavera.bo.base.CreateEngineImpl.prepareForCreate(Unknown Source)
at com.primavera.bo.base.CreateEngineImpl.create(Unknown Source)
at com.primavera.bo.base.server.ServerDAOImpl.create(Unknown Source)
at com.primavera.summarizer.dao.AssignmentDAO.persistFields(Unknown Source)
at com.primavera.summarizer.ProjectDataSummarizer.a(Unknown Source)
at com.primavera.summarizer.ProjectDataSummarizer.summarize(Unknown Source)
at com.primavera.summarizer.Summarizer.a(Unknown Source)
at com.primavera.summarizer.Summarizer.a(Unknown Source)
at com.primavera.summarizer.Summarizer.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.runAsapJob(Unknown Source)
at com.primavera.jobsvc.common.JobServiceExecutor.runAsapJob(Unknown Source)
at com.primavera.bre.SubSystemFacadeImpl.asapSummarize(Unknown Source)
at com.primavera.bo.remotable.JobSubmitter.submitAsapJob(Unknown Source)
at com.primavera.bo.remotable.qproxy.JobSubmitter.submitAsapJob(Unknown Source)
at com.primavera.bo.DBJobSubmitter.submitAsapJob(Unknown Source)
at com.primavera.bo.services.helper.SubmitJob.execute(Unknown Source)
at com.primavera.bo.services.helper.SubmitJob.execute(Unknown Source)
at com.primavera.bo.remotable.AsyncJobSvcHdlr$TxnJob.execute(Unknown Source)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)

Cause