My Oracle Support Banner

Upgrep Failed: ORA-01407: cannot update ("SIEBEL"."S_USER_EVENT"."LOGIN") to NULL (Doc ID 2697509.1)

Last updated on AUGUST 07, 2020

Applies to:

Siebel CRM - Version 20.6 and later
Information in this document applies to any platform.

Symptoms

Upgrading Siebel, the Upgrep process failed with the following errors in the upgwhiz.log

UpgradeLog UpgradeError 1 000000025f201420:0 2020-07-28 10:49:36 [tp][ODBC Oracle driver][Oracle]ORA-01407: cannot update ("SIEBEL"."S_USER_EVENT"."LOGIN") to NULL

UpgradeLog UpgradeError 1 000000025f201420:0 2020-07-28 10:49:36 Error in function UTLOdbcExecDirect

UpgradeLog UpgradeError 1 000000025f201420:0 2020-07-28 10:49:36 Error executing sql statement (

UPDATE S_USER_EVENT SET LOGIN=(SELECT LOGIN FROM S_USER WHERE

S_USER.ROW_ID=S_USER_EVENT.USER_ID)).

UpgradeLog UpgradeError 1 000000025f201420:0 2020-07-28 10:49:36 Error executing statement (RUN_SQL_30) in file (pret_irm.sql).

UpgradeLog UpgradeInfo 3 000000025f201420:0 2020-07-28 10:49:36 Close database connection.

UpgradeLog UpgradeError 1 000000025f201420:0 2020-07-28 10:49:36 Execute SQL file action failed.

UpgradeLog UpgradeError 1 000000025f201420:0 2020-07-28 10:49:36 Error executing action (Prepare for table creation).

UpgradeLog UpgradeInfo 3 000000025f201420:0 2020-07-28 10:49:36 Status Message (Errors encountered)

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
References


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