Error: "ORA-14402: updating partition key column would cause a partition change" When Attempting to Convert a Project to a Baseline

(Doc ID 2283398.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

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

Symptoms

When attempting to convert a project to a baseline in the Maintain Baseline dialog window the following error is observed:

Executable: PM.exe
Application: Primavera P6 Professional R16.2
Event Code: PRMDB-2963-F
Message: PRM DBAccess Error: Error executing query. Error: ORA-14402: updating partition key column would cause a partition change

customer used orpm_table_redefinition.sql to enable the table partitioning.

Steps to Duplicate:

  1. Create two projects, A1 and B1
  2. Open project A1
  3. Go to Project/Maintain Baselines...
  4. Click on Add
  5. Select "Convert another project to be a new baseline of the current project"
  6. Select project B1
  7. Observe error

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