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 JUNE 29, 2016

Applies to:

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

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

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