We have restored a Clarity dataset backup and sequences are out of sync.
We are having all sorts of errors on the application. Logs are complaining about sequences. Error sample:
Caused by: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.ODF_AUD_OBJ_INST_CONTEXT_PK) violated
As we fix a specific sequence issue, we encounter the same on a different one.
Can we reset all the sequences in some way?
Hot back up was taken and used for the restore
Reset all the sequences using the sql attached