Getting A Lot Of Errors "Nextkey limit reached for column pxjobrun_jobrun_id " In Primavera HTML Log (Doc ID 2290773.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

When attempting to publish project in P6 Web, the job shows as "Failed" in the "View status" window.

The following error message appears in the P6WebAccess.html log:

AWST PrmThread-23 ERROR DB Id: 8 com.primavera.px.common.PxServiceJobRunDAO ?:? Couldn't create JobRun record

AWST Thread-112 ERROR DB Id: 8 com.primavera.infr.srvcs.NextKeyServiceImpl ?:? Next key limit reached for column pxjobrun_jobrun_id.
Please contact administrator for record maintenance

AWST Thread-112 ERROR DB Id: 8 com.primavera.infr.srvcs.NextKeyServiceImpl ?:? An attempt to fetch a new NextKey for pxjobrun_jobrun_id failed.
com.primavera.PhoenixException: An attempt to fetch a new NextKey for pxjobrun_jobrun_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.px.common.PxServiceJobRunDAO.createJobRunRecord(Unknown Source)
at com.primavera.px.common.PxService.a(Unknown Source)
at com.primavera.px.common.PxService.b(Unknown Source)
at com.primavera.px.common.PxService.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.execute(Unknown Source)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)


STEPS

The issue can be reproduced at will with the following steps:
1. Login P6 Web.
2. Manually publish a project.
3. Observe the "Failed" status within the "View status" window.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot use P6 job services to publish a project.

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