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 AUGUST 09, 2023
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
ALTER TABLE DISCUSSION
ADD CONSTRAINT fk_<foreign key constraint> FOREIGN KEY (<affected column>)
REFERENCES <DATABASE TABLE> (<affected column>)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!