My Oracle Support Banner

Error 'ORA-02270: no matching unique or primary key for this column-list' and P6 EPPM Database Schema Upgrade Fails with Error (Doc ID 2966354.1)

Last updated on MARCH 20, 2024

Applies to:

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

Symptoms

When attempting to upgrade the P6 EPPM database schema using the dbsetup.bat utility, the following error occurs.

ORA-02270: no matching unique or primary key for this column-list
SQL Query:
ALTER TABLE DISCUSSION
 ADD CONSTRAINT fk_<foreign key constraint> FOREIGN KEY (<affected column>)
 REFERENCES <DATABASE TABLE> (<affected column>)

Changes

 

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.