Ohi 3.20.3 Error: ORA-02292 Integrity Constraint
(Doc ID 2834872.1)
Last updated on JANUARY 20, 2022
Applies to:
Oracle Health Insurance Claims Adjudication - Version 3.20.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 3.20.3.0.0 version, Installation
Receiving the following error:
ERROR
-----------------------
ERROR liquibase.changelog.ChangeSet - Change Set 2020-09-18_NXT-20851.xml::1:failed. Error: ORA-02292: integrity constraint (OHI_CLAIMS_OWNER.OHI_MESSAGE_GROUP_DETAIL_FK2) violated - child record found
[Failed SQL: (2292) delete from ohi_messages_b where code in ( 'OIG-GATE-041', 'OIG-GATE-042', 'OIG-GATE-043')]
[SEVERE] Liquibase update failed. Please check the log file upgrade_OHI_CLAIMS_OWNER_phase_major_1.log for more details
ERROR com.oracle.healthinsurance.install.Install$LiquibaseInvoker - Liquibase Update Failed: %s
liquibase.exception.MigrationFailedException: Migration failed for change set
Reason: liquibase.exception.DatabaseException: ORA-02292: integrity constraint (OHI_CLAIMS_OWNER.OHI_MESSAGE_GROUP_DETAIL_FK2) violated - child record found
[Failed SQL: (2292) delete from ohi_messages_b where code in ( 'OIG-GATE-041', 'OIG-GATE-042', 'OIG-GATE-043')]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:659)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97)
at liquibase.Liquibase.update(Liquibase.java:201)
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 |
| References |