My Oracle Support Banner

Siebel Database Upgrade to IP2017 or Later Fails With ORA-01407: cannot update to NULL Error On S_USER_KEY_ATT And S_USER_ATTJOIN Tables During Upgrep Execution (Doc ID 2672994.1)

Last updated on JUNE 09, 2020

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade from any lower version to IP2017 or later, the upgrep step fails and the following error occurs in upgwiz.log (Windows) or srvrupgwiz.log (UNIX/LINUX)

update S_USER_KEY_ATT set NAME = (select C1.NAME from S_UK_ATTJOIN UKAJ_PJ , S_COLUMN C1 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 ) where not exists (select 'anything' from S_UK_ATTJOIN UKAJ_IJ where UKAJ_IJ.USER_KEY_ATT_ID = S_USER_KEY_ATT.ROW_ID and UKAJ_IJ.JOIN_SEQUENCE = 2 )

...
DBCLog DBCLogError 1 000000025ec24314:0 2020-05-18 14:51:54 [tp][ODBC Oracle driver][Oracle]ORA-01407: cannot update ("SIEBEL"."S_USER_KEY_ATT"."NAME") to NULL
UpgradeLog UpgradeError 1 000000025ec24314:0 2020-05-18 14:51:54 [tp][ODBC Oracle driver][Oracle]ORA-01407: cannot update ("SIEBEL"."S_USER_KEY_ATT"."NAME") to NULL
UpgradeLog UpgradeError 1 000000025ec24314:0 2020-05-18 14:51:54 Erreur la fonction UTLOdbcExecDirect
...
UpgradeLog UpgradeError 1 000000025ec24314:0 2020-05-18 14:51:54 Erreur de l'exécution de l'instruction (RUN_SQL_270) le fichier (repos_upgrade.sql).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform upgrade to IP2017 or later version from any version
2. Make sure that upgrep is started
3. Check to see if upgrep completes


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
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.