My Oracle Support Banner

Error 'An attempt to fetch a new NextKey for <KEY NAME> failed' or '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 APRIL 07, 2020

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

For certain actions in P6 Professional or P6 Web (for example, attempting to Summarize projects), the job process fails and logs one or more of the following errors:

Example:
ERROR com.primavera.infr.srvcs.NextKeyServiceImpl - An attempt to fetch a new NextKey for sumtrsrc_sumtrsrc_id failed.

 

Other possible KEY NAME values include, but are not limited to:

  • sumtrsrc_sumtrsrc_id
  • task_task_id
  • taskrsrc_taskrsrc_id
  • taskpred_task_pred_id
  • taskproc_proc_id
  • projwbs_wbs_id
  • actvcode_actv_code_id

The first part of the KEY NAME is the database table, the second part is the relevant Primary Key field in that table.

Changes

 

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!

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