Error: "An Attempt to Fetch a New NextKey for Sumtrsrc_sumtrsrc_id Failed; Caused By: java.sql.SQLException: Numeric Overflow" When Running Project Summarization (Doc ID 1644621.1)

Last updated on JUNE 27, 2016

Applies to:

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

Symptoms

When attempting to summarize a project, the summarization job fails and the following error occurs in the P6WebAccesslog.html file:

ERROR
-----------------------

com.primavera.summarizer.SummarizerException: Error while persisting assignment summary rollups for project XXXX and wbs ids = [XXXX]
    at com.primavera.summarizer.strategy.AssignmentSummaryStrategy.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.execute(Unknown Source)
    at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)
   Caused by: 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.create(Unknown Source)
    at com.primavera.bo.base.server.ServerDAOImpl.create(Unknown Source)
    at com.primavera.summarizer.strategy.AssignmentSummaryStrategy.persistFields(Unknown Source)
    at com.primavera.summarizer.ProjectDataSummarizer.a(Unknown Source)
    at com.primavera.summarizer.ProjectDataSummarizer.summarize(Unknown Source)
    ... 6 more
   Caused by: java.sql.SQLException: Numeric Overflow
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
    at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4319)
    at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:127)
    at oracle.jdbc.driver.OracleCallableStatement.getInt(OracleCallableStatement.java:1176)
    at oracle.jdbc.driver.OracleCallableStatementWrapper.getInt(OracleCallableStatementWrapper.java:783)
    at com.primavera.infr.db.PCallableStatement.getInt(Unknown Source)
    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.strategy.AssignmentSummaryStrategy.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)
    ... 3 more

 
 

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