Error ORA-02291: Integrity constraint in Empower message center - WKB306200

SYMPTOMS

• Cannot store injection in recover log
• ORA-02291: Integrity constraint error in the Empower message center

ENVIRONMENT

• Empower
• Customer runs Linux database and their own Oracle licenses

CAUSE

The SampleSet.dat file fails to recover as a result of a NULL or missing value in the Injection ID and/or Vial ID.

We believe intermittent network issues can result in such a case.

FIX or WORKAROUND

1. Look in C:\Empower folder\instrumentserver\systemname\Database name\projectname.
2. Look for SampSet.dat and xxxx.dat files that are unreadable and cannot be uploaded to server.

ADDITIONAL INFORMATION

Contact Waters Professional Services, which may be able to assist further to identify where the issue lies and if it can be repaired.

[CRI-8150] Unable to store injection ORA-02291: integrity constraint (W_IMPURITIES_09B.FK_INJECTION_SS_ID) violated - parent key not found