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 OCTOBER 04, 2021
Applies to:
Siebel CRM - Version 17.0 [IP2017] and laterInformation 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
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 |