Error: ORA-02291: Integrity constraint in Empower message center - WKB306200
Article number: 306200
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
- Look in C:\Empower folder\instrumentserver\systemname\Database name\projectname.
- 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.
id306200, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP