Error: "ORA-14402: Updating Partition Key Column Would Cause a Partition Change" When Upgrading P6 Database (Doc ID 1956880.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

When attempting to upgrade a database via DBSetup.bat, the follow error message appears in the DatabaseSetup.log:

ERROR

--------

<12.12.2014 04:01:31> [INFO] [2014-12-12 04:01:31] UPDATE UDFVALUE UV SET TABLE_NAME = (SELECT TABLE_NAME FROM UDFTYPE UT WHERE UT.UDF_TYPE_ID = UV.UDF_TYPE_ID)
<12.12.2014 05:07:53> [ERROR] [2014-12-12 05:07:53] ORA-14402: updating partition key column would cause a partition change

<12.12.2014 05:07:53> [ERROR] [2014-12-12 05:07:53] Database Error: error number=14402
<12.12.2014 05:07:53> [ERROR] [2014-12-12 05:07:53] Error Message: ORA-14402: updating partition key column would cause a partition change

<12.12.2014 05:07:53> [WARN] [2014-12-12 05:07:53] [USER] Could not complete because the job "Run SQL Script ORPM_p82sp2f10.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-14402: updating partition key column would cause a partition change

at com.primavera.database.tools.ScriptRunner.ScriptRunner.runSQL(ScriptRunner.java:209)
at com.primavera.database.tools.ScriptRunner.ScriptRunner.run(ScriptRunner.java:145)
at com.primavera.database.tools.dbmt.workflow.SqlScriptJob.doJob(SqlScriptJob.java:86)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
at com.primavera.database.tools.dbmt.WorkflowStepJob.doJob(WorkflowStepJob.java:49)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:195)
at com.primavera.database.tools.dbmt.cmd.CmdLineWizardRunnerFactory$1.commit(CmdLineWizardRunnerFactory.java:173)
at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.run(JobTreeTypeDef.java:252)
at java.lang.Thread.run(Thread.java:745)
at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.runJobs(JobTreeTypeDef.java:245)
at com.primavera.database.tools.dbmt.actions.TransitionMap.initializeCommitPage(TransitionMap.java:339)
at com.primavera.database.tools.dbmt.actions.TransitionMap.initialize(TransitionMap.java:131)
at com.primavera.database.tools.dbmt.actions.PropertyWizardNavigationAction.tryToLeavePage(PropertyWizardNavigationAction.java:53)
at com.primavera.database.tools.dbmt.cmd.CmdLineWizardRunnerFactory$1.performWizardAction(CmdLineWizardRunnerFactory.java:147)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runWizard(BaseWizardRunner.java:76)
at com.primavera.database.tools.dbmt.actions.WizardActionOperation.perform(WizardActionOperation.java:90)
at com.primavera.database.tools.dbmt.cmd.CmdLineApplicationRunner.start(CmdLineApplicationRunner.java:69)
at com.primavera.database.tools.dbmt.Main.main(Main.java:91)

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