XML Import via P6 Web Fails With Error "Next Key Limit Reached for Column Alert_alert_id" (Doc ID 2115709.1)

Last updated on MARCH 17, 2016

Applies to:

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

Symptoms

On : Primavera P6 Enterprise Project Portfolio Management 15.2.3.0 version, P6 Web

When attempting to do an XML import via P6 web, the following error occurs:

ERROR
-----------------------
[NextKeyServiceImpl] ERROR 00:55:18,708: Next key limit reached for column alert_alert_id. Please contact administrator for record maintenance
[NextKeyServiceImpl] ERROR 00:55:18,708: An attempt to fetch a new NextKey for alert_alert_id failed.
com.primavera.PhoenixException: An attempt to fetch a new NextKey for alert_alert_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.guiservices.impexp.ImportExportServiceImpl.addAlert(Unknown Source)
  at com.primavera.guiservices.impexp.ImportExportServiceImpl.b(Unknown Source)
  at com.primavera.guiservices.impexp.ImportExportServiceImpl.doImport(Unknown Source)
  at com.primavera.guiservices.impexp.ImportExportWorker.execute(Unknown Source)
  at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
  at java.lang.Thread.run(Thread.java:745)

[ImportExportServiceImpl] ERROR 00:55:18,708: Failure adding alert to Export/Import Project service for the Job id 12210
com.primavera.PhoenixException: An attempt to fetch a new NextKey for alert_alert_id failed.
  at com.primavera.infr.srvcs.NextKeyServiceImpl.a(Unknown Source)
  at com.primavera.infr.srvcs.NextKeyServiceImpl.getNextKey(Unknown Source)


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