Upgphys Enable Workspace Fails with Error ORA-00001: unique constraint (SIEBEL.S_LST_OF_VAL_U1) violated

(Doc ID 2332772.1)

Last updated on NOVEMBER 29, 2017

Applies to:

Siebel Core - DB Deployment and Configuration - Version 17.0 [IP2017] to 17.2 [IP2017] [Release V17]
Information in this document applies to any platform.

Symptoms

 While upgrading to Siebel IP17, the upgphys may fail while enabling workspaces with the following error:

ODBC driver: seor827.dll version 07.15.0159 (B0270, U0182)
UPDATE SIEBEL.S_LST_OF_VAL set WS_SRC_ID=ROW_ID , WS_ID='1@90620' , WS_MIN_VER=0 , WS_MAX_VER = 10000
ODBC error 23000 in SQLExecDirect:
[tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_LST_OF_VAL_U1) violated

or

[tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_LST_OF_VAL_U2) violated

Changes

 

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