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 MARCH 22, 2022

Applies to:

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


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


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


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.


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


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

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