Skip to main content
Waters

Oracle error with Empower 3: ORA-02291 : Integrity constraint (Milleinum.FK_SystemGroup_Systemnode) Violated - Parent Key not found - WKB81133

Article number: 81133

SYMPTOMS

  • Changing access from owner to owner group world generated an Oracle error: ORA-02291: Integrity constraint (Milleinum.FK_SystemGroup_Systemnode) Violated - Parent Key not found

ENVIRONMENT

  • Empower 3

CAUSE

During the migration from a test database to a production database, the option to use System Objects was selected. The production database still had reference to the test node.

FIX or WORKAROUND

  1. Delete and re-create the node.
  2. You can now create the new system and set changes as required.

ADDITIONAL INFORMATION

 

id81133, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP

Not able to find a solution? Click here to request help.