Kbase P129101: SQL: Error (7597) executing ALTER TABLE ADD CONSTRAINT with FOREIGN KEY statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Error (7597) executing ALTER TABLE ADD CONSTRAINT with FOREIGN KEY statement.
=== SQL Exception 1 ===
SQLState=23000
ErrorCode=-20116
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Constraint violation (7597)
Executing ADD CONSTRAINT with FOREIGN KEY after executing DROP CONSTRAINT for the same table and the same CONSTRAINT generates the error.
Executing a statement similar to the following generates the error:
ALTER TABLE pub.Test2 ADD CONSTRAINT Fk_Test2_Test1_Field2 FOREIGN KEY ( Field2 ) REFERENCES pub.Test1 ( Field1 );
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
CAUSE:
Bug# OE00162867
FIX:
Upgrade to OpenEdge 10.1C or later