search cancel

Clarity sequences out of sync after restoring Hot Backup

book

Article ID: 254592

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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?

Cause

Hot back up was taken and used for the restore

Resolution

Reset all the sequences using the sql attached

Attachments

1668760821176__Sequence_update.sql get_app