Errors When Upgrading a Database Using DBSetup.bat - "Error in Run SQL Script ORPM_P201202.sql", "ORA-01451: column to be modified to NULL cannot be modified to NULL", "ALTER TABLE CHGUDFVALUEX modif fk_id NULL" (Doc ID 2855031.1)

Last updated on MARCH 22, 2022

Applies to:

Symptoms

When attempting to upgrade a P6 EPPM database, via DBSetup.bat, the following error occurs on the 3rd step: "Perform core upgrade steps":

ERROR

Error in Run SQL Script ORPM_P201202.sql : DatabaseToolE.....
ORA-01451: column to be modified to NULL cannot be modified to NULL
SQL Query:
ALTER TABLE CHGUDFVALUEX modif fk_id NULL

DatabaseSetup.log shows the following:

01.28.2022 08:09:56 [INFO] [USER] Upgrade from schema version 2012.0002.0000.0001 to schema version 2012.0011.0000.0001
01.28.2022 08:09:58 [INFO] [USER] About to add 0 jobs
01.28.2022 08:09:58 [INFO] [USER] Finished adding 0 jobs
01.28.2022 08:10:08 [INFO] [USER] About to add 0 jobs
01.28.2022 08:10:08 [INFO] [USER] Finished adding 0 jobs
01.28.2022 08:10:12 [INFO] [USER] About to add 15 jobs
01.28.2022 08:10:12 [INFO] [USER] Finished adding 15 jobs
01.28.2022 08:10:15 [INFO] [USER] Job Starting: Gather Source Code
01.28.2022 08:10:15 [INFO] [USER] Job Starting: Run SQL Script orpm_gather_source_code.sql
01.28.2022 08:10:15 [INFO] [USER] Job Finished: Run SQL Script orpm_gather_source_code.sql
01.28.2022 08:10:15 [INFO] [USER] Job Finished: Gather Source Code
01.28.2022 08:10:15 [INFO] [USER] Job Starting: Grant Required Privileges for Upgrade
01.28.2022 08:10:15 [INFO] [USER] Job Starting: Run SQL Script orpm_create_bguser_upgrade.sql
01.28.2022 08:10:15 [INFO] [USER] Job Finished: Run SQL Script orpm_create_bguser_upgrade.sql
01.28.2022 08:10:15 [INFO] [USER] Job Starting: Run SQL Script orpm_grant_privileges.sql
01.28.2022 08:10:16 [INFO] [USER] Job Finished: Run SQL Script orpm_grant_privileges.sql
01.28.2022 08:10:16 [INFO] [USER] Job Finished: Grant Required Privileges for Upgrade
01.28.2022 08:10:16 [INFO] [USER] Job Starting: Perform core upgrade steps
01.28.2022 08:10:16 [INFO] [USER] Job Starting: Run SQL Script or_disable_triggers.sql
01.28.2022 08:10:17 [INFO] [USER] Job Finished: Run SQL Script or_disable_triggers.sql
01.28.2022 08:10:17 [INFO] [USER] Job Starting: Run SQL Script ORPM_P201202.sql
01.28.2022 08:10:18 [ERROR] ORA-01451: column to be modified to NULL cannot be modified to NULL

01.28.2022 08:10:18 [ERROR] Database Error: error number=1451
01.28.2022 08:10:18 [ERROR] Error Message: ORA-01451: column to be modified to NULL cannot be modified to NULL

01.28.2022 08:10:18 [WARN] [USER] Could not complete because the job "Run SQL Script ORPM_P201202.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-01451: column to be modified to NULL cannot be modified to NULL

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:67)
at com.primavera.database.tools.dbmt.WorkflowStepJob.doJob(WorkflowStepJob.java:49)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:67)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:205)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.commit(BaseWizardRunner.java:214)
at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.run(JobTreeTypeDef.java:253)
at java.lang.Thread.run(Thread.java:748)

01.28.2022 08:10:18 [INFO] [USER] Job Failed: Run SQL Script ORPM_P201202.sql
01.28.2022 08:10:18 [INFO] [USER] Job Failed: Perform core upgrade steps

Cause

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