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
- Delete and re-create the node.
- 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