Full Upgrade from 8.0 to 18.8 fails during Upgrep on SQL_220 with Error ORA-01407 (Doc ID 2444811.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

On : 18.8 version, Upgrade

When attempting to run a full upgrade from Siebel CRM 8.0.0.012  it fails, and the following error can be see in upgwiz.log:

ERROR
----------------------

UpgradeLog UpgradeInfo 3 000000025b9317ac:0 2018-09-08 09:11:13 Executing SQL statement RUN_SQL_220:

update S_USER_KEY_ATT

set NAME =

(select    C6.NAME || '/'

       || C5.NAME || '/'

       || C4.NAME || '/'

       || C3.NAME || '/'

       || C2.NAME || '/'

       || C1.NAME

from S_UK_ATTJOIN UKAJ_PJ

,    S_COLUMN     C1

,    S_UK_ATTJOIN UKAJ_IJ

,    S_COLUMN     C2

,    S_UK_ATTJOIN UKAJ_I2

,    S_COLUMN     C3

,    S_UK_ATTJOIN UKAJ_I3

,    S_COLUMN     C4

,    S_UK_ATTJOIN UKAJ_I4

,    S_COLUMN     C5

,    S_UK_ATTJOIN UKAJ_I5

,    S_COLUMN     C6

where UKAJ_PJ.USER_KEY_ATT_ID = S_USER_KEY_ATT.ROW_ID

and   UKAJ_PJ.JOIN_COL_ID = C1.ROW_ID

and   UKAJ_PJ.JOIN_SEQUENCE = 1

and   UKAJ_PJ.USER_KEY_ATT_ID = UKAJ_IJ.USER_KEY_ATT_ID

and   UKAJ_IJ.JOIN_COL_ID = C2.ROW_ID

and   UKAJ_IJ.JOIN_SEQUENCE = 2

and   UKAJ_PJ.USER_KEY_ATT_ID = UKAJ_I2.USER_KEY_ATT_ID

and   UKAJ_I2.JOIN_COL_ID = C3.ROW_ID

and   UKAJ_I2.JOIN_SEQUENCE = 3

and   UKAJ_PJ.USER_KEY_ATT_ID = UKAJ_I3.USER_KEY_ATT_ID

and   UKAJ_I3.JOIN_COL_ID = C4.ROW_ID

and   UKAJ_I3.JOIN_SEQUENCE = 4

and   UKAJ_PJ.USER_KEY_ATT_ID = UKAJ_I4.USER_KEY_ATT_ID

and   UKAJ_I4.JOIN_COL_ID = C5.ROW_ID

and   UKAJ_I4.JOIN_SEQUENCE = 5

and   UKAJ_PJ.USER_KEY_ATT_ID = UKAJ_I5.USER_KEY_ATT_ID

and   UKAJ_I5.JOIN_COL_ID = C6.ROW_ID

and   UKAJ_I5.JOIN_SEQUENCE = 6

)

where exists

(select 'anything'

from S_UK_ATTJOIN UKAJ_I5

where UKAJ_I5.USER_KEY_ATT_ID = S_USER_KEY_ATT.ROW_ID

and   UKAJ_I5.JOIN_SEQUENCE = 6

)

DBCLog DBCLogError 1 000000025b9317ac:0 2018-09-08 09:11:19 [tp][ODBC Oracle driver][Oracle]ORA-01407: cannot update ("SIEBEL"."S_USER_KEY_ATT"."NAME") to NULL

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install 18.8
2. run upgrep
3. fails with mentioned error

Changes

Cause

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