My Oracle Support Banner

Getting SQL execution error, ORA-00001: unique constraint (ARGUS_APP.UC_CMN_AUDIT_LOG_AUDIT_ID) violated When Upgrading From 6.0.1 To 7.0.1 (Doc ID 1589511.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 7.0.3 and later
Information in this document applies to any platform.

Symptoms

Getting the following error when upgrading from 6.0.1 to 7.0.1, upgrade is completed with one error:


SQL execution error, ORA-00001: unique constraint (ARGUS_APP.UC_CMN_AUDIT_LOG_AUDIT_ID) violated
ORA-06512: at line 10


This is the sql where we got unique constraint violation error.
declare
cursor c1 is
select rowid
from cmn_audit_log
where audit_id is null;
ln_audit_id number;
begin
for x in c1 loop
select PKG_CONSOLE_UTIL.F_GET_SEQ_NEXT_VAL('S_CMN_AUDIT_LOG_AUDIT_ID') into ln_audit_id from dual;
update cmn_audit_log
set audit_id = ln_audit_id
where rowid = x.rowid;
end loop;
commit;
end;


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.