P6 Database Constraint Validation Error: "The ALTER TABLE statement conflicted with the FOREIGN KEY constraint <constraint name>. The conflict occurred in database <database name>, table <table name>, column <column name>"
(Doc ID 1625968.1)
Last updated on AUGUST 08, 2023
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 8.2.2.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to add constraints, that were missing from a schema validation, the following error occurs:
ERROR
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint <constraint name>. The conflict occurred in database <database name>, table <table name>, column <column name>.
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! |
In this Document
Symptoms |
Cause |
Solution |