My Oracle Support Banner

Upgrep Failed With The Error "ORA-00001: unique constraint (SIEBEL.S_EVT_ACT_CAL_U1) violated " (Doc ID 2183410.1)

Last updated on SEPTEMBER 04, 2024

Applies to:

Siebel eMedical - Version 16.0 [IP2016] and later
Information in this document applies to any platform.

Symptoms

 

On : 16.0 [IP2016] version, Upgrade

Upgrep Failed With The Error "ORA-00001: unique constraint (SIEBEL.S_EVT_ACT_CAL_U1) violated "

Database upgrade (upgrep) has been launched to upgrade from 8.1.1.3 to IP2016 via Database Server Configuration utility. Then it failed with the message "Upgrade Wizard did not complete successfully." Upgwiz.log shows the following error message.

Error
-----------------------
SQLError Statement 0 00000002577e1130:0 2016-07-07 21:10:57 SQL Statement:
 INSERT INTO S_EVT_ACT_CAL (ROW_ID,CREATED,CREATED_BY,LAST_UPD, LAST_UPD_BY,DB_LAST_UPD,DB_LAST_UPD_SRC,PAR_ROW_ID, ALLDAY_FLG) SELECT ROW_ID, {fn now()}, '0-1',{fn now()}, '0-1',{fn now()}, 'DataMigration',ROW_ID, 'N' FROM S_EVT_ACT WHERE CAL_TYPE_CD= 'Calendar and Activities'

DBCLog DBCLogError 1 00000002577e1130:0 2016-07-07 21:10:57 [tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_EVT_ACT_CAL_U1) violated


Steps
-----------------------
1. Install Siebel Enterprise Server IP2016.
2. Launch Database Server Configuration.
3. Run database upgrade (upgrep).


Business Impact
-----------------------
Due to this error, migration to IP2016 cannot be done.

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.