When running a full cleanup, we received a “unique constraint” violation error during the Record Data Cleanup phase. It was observed after upgrade from 3.4.1/10.4.1 to 3.5.0/10.5.0 as follows:
ORA-00001: unique constraint (TRIRIGA.PK_IBS_SPEC_ASSIGNMENTS) violated; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TRIRIGA.PK_IBS_SPEC_ASSIGNMENTS) violated [MID-3584547215] com.tririga.platform.util.StackTrace: Package Cleanup Error.
We resolved an issue when the Platform Maintenance Scheduler attempted to add missing associations, but the associations already exist.
[Admin: This post is related to the 07.14.15 post about renaming the Cleanup Agent to Platform Maintenance Scheduler.]