We are experiencing a problem in the upgrade from OpenSpecimen 2.5 to 3.4.
We get a few warnings, and the following error:
liquibase.exception.DatabaseException: java.sql.SQLIntegrityConstraintViolationException: ORA-02299: cannot validate (OPENSPECIMEN34.CAT_SPEC_CP_ID_LABEL_UQ) - duplicate keys found
There are duplicates according to how that constraint is set up. We have a lot of entries in the CATISSUE_SPECIMEN table with null values for the LABEL column. These are showing up as duplicates.
How can we resolve this problem?
Thank you.