Custom Authentication Component Exception - ORA-00001: unique constraint. (Database restoration, Oracle, PK violated, Unique Constraint)

Summary

This message might occur when a Bizagi database backup is restored. It usually occurs with projects using an Oracle database.

Bizagi 9.1.x, 10.x Oracle

When a Bizagi database backup is restored, the following error might occur when the Work Portal is executed in the browser:

Date Time:

9/13/2012 11:53:56 AM

Source:

BizAgi.Authentication

Message:

Custom Authentication Component Exception - ORA-00001: unique constraint

(PROD_QVIT_NEWAVATAR_ORCL.BIZAGILOG_PK) violated

ORA-06512: at "PROD_QVIT_NEWAVATAR_ORCL.SPBA_WFE_ADD_TO_BIZAGILOG", line 8

ORA-06512: at line 1

When a database export in Oracle is made, sometimes the sequences values are exported incorrectly.

In order to fix this error, it’s necessary to execute the attached script on the Bizagi database:

You can optionally provide a password to protect this file. Leave the password fields blank to remove any current password.
Password:
Confirm Password:
Update Password