My Oracle Support Banner

"ORA-02289 Sequence Does Not Exist" When Attempting to Copy a Project via P6 Professional (Doc ID 2450070.1)

Last updated on DECEMBER 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 to 17.12.8.0 [Release 15.1 to 17.12]
Information in this document applies to any platform.

Symptoms

When attempting to copy a project via P6 Professional, the following error occurs:


ERROR

ORA-02289: sequence does not exist


Error Details:

PrmThread-142 ERROR DB Id: 2 com.primavera.dbcrudutil.CopyProjectJobService ?:? Error while running Copy Project Service:PreparedStatementCallback; bad SQL grammar [insert into PC_PROCESS_STAT (PC_PROCESS_STAT_ID,EXECUTION_ID,PROCESS_NAME,STEP_NAME,STATUS,ESTIMATED_TIME) values(PC_PROCESS_STAT_SEQ.nextval,?,?,?,?,?)]; nested exception is java.sql.BatchUpdateException: ORA-02289: sequence does not exist


STEPS

The issue can be reproduced at will with the following steps:

  1. Login in to the P6 Professional client.
  2. Copy Paste a project.
  3. Observe the reported error.

BUSINESS IMPACT

Due to this issue, users cannot Copy / Paste projects with baselines.

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!


In this Document
Symptoms
Cause
Solution


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