My Oracle Support Banner

P6 EPPM Database Upgrade to 20.12.x on SQL Server Fails With Error "The index 'ndx_doc_2' is dependent on column 'doc_uuid'" (Doc ID 2814486.1)

Last updated on MARCH 20, 2024

Applies to:

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

Symptoms

When attempting to upgrade a Microsoft SQL Server database from 19.12.x to 20.12.x, the following error occurs (Note: the exact script name depends on what P6 version+patchset the database is being upgraded from).

<date-time stamp> [ERROR] Database Error: error number=5074
<date-time stamp> [ERROR] Error Message: The index 'ndx_doc_2' is dependent on column 'doc_uuid'.
<date-time stamp> [WARN] [USER] Could not complete because the job "Run SQL Script sspm_p1912##.sql" failed.
com.primavera.database.tools.DatabaseToolException: The index 'ndx_doc_2' is dependent on column 'doc_uuid'.
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(Unknown Source)

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!

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