Custom Authentication Component Exception - ORA-00001: unique constraint.

4 Years Ago
JorgeR
BIZAGI STUDIO

Summary

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

Applies to

Bizagi 9.1.x, 10.x Oracle

Symptoms

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

Cause

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

Solution

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


Attachments


FixIdentitiesValues-Oracle.sql FixIdentitiesValues-Oracle.sql (4.00 KB, 860 views)

Details

Last Modified:4 Years Ago
Last Modified By: JorgeR
Type: ERROR
Level: Beginner
Rated 4 stars based on 1 vote
Article has been viewed 6.6K times.

Options