Unique constraint violated when closing a Biology Experiment

Unique constraint violated when closing a Biology Experiment

PROBLEM:

Any Biology Experiment cannot be closed. Rendering works fine, but the following error occurs when submitting a rendered PDF:

"Sorry, an error occurred while executing the SQL "INSERT INTO ELN_SIGNED_VERSIONS (version_key, submission_receipt) VALUES (:vkey,:receipt)": ORA-00001: unique constraint (CS_NOTEBOOK9.ENP_SIGNED_VERSIONS) violated."


REASON:

There was an extra transition listener named “Sign and Close” in

Everyone -> Configuration -> Collection Types -> Biology Experiment -> [right click] -> Collection Type Configuration -> States -> Open -> Transition Types -> Sign and Close -> Transition listeners.

Two listeners (“Sign Version” and “Sign and Close”) were doing the same thing, thus causing the “unique constraint violated” error. Both are using the same Implementation (displayed on the right once you click on the listener).


SOLUTION:

Deleting the duplicate listener (“Sign and Close”) from Biology Experiment resolved the issue.