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

(Doc ID 2183410.1)

Last updated on SEPTEMBER 22, 2016

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms