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

SYMPTOMS

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

ENVIRONMENT

• Empower
• Customer running Linux database and 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.

It is believed 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 who 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