My Oracle Support Banner

The Siebel Database Schema Upgrade kit fails when loading S_UI* data after workaround in 2330266.1 (Doc ID 2654435.1)

Last updated on APRIL 01, 2020

Applies to:

Siebel Anywhere - Version 16.19 [IP2016] and later
Information in this document applies to any platform.

Symptoms

After creating a Siebel Database Schema upgrade kit using the workaround in 2330266.1, when the remote client tries to apply the upgrade kit, it fails. The upgwiz.log files shows:

ERROR
-----------------------
SQLStatementOptions Execute 4 000000025e711888:0 2020-03-17 18:04:53 (SQLExecute) Conn Handle: 4108672, Stmt Handle: 4124376, Time: 0s
SQLError Statement 0 000000025e711888:0 2020-03-17 18:04:53 SQL Statement:
insert into SIEBEL.S_UI_OBJECT (ROW_ID,
CREATED,
CREATED_BY,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
CONFLICT_ID,
INACTIVE_FLG,
NAME,
REPOSITORY_ID,
TYPE_CD,
USAGE_TYPE_CD,
DB_LAST_UPD,
COMMENTS,
DB_LAST_UPD_SRC,
RECORD_SRC) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_date, ?, '', ?)
SQLError Bind Variables 1 000000025e711888:0 2020-03-17 18:04:53 01:1-2VAL-4Z2WN
02:2017-05-25 15:52:33
03:0-1
04:2017-05-25 15:52:33
05:0-1
06:0
07:0
08:Y
09: Catalog Product Add to Cart Applet CXPRM
10:1-2VAL-1
11:Applet
12:Physical Renderer
13:
14:Siebel Internal

DBCLog DBCLogError 1 000000025e711888:0 2020-03-17 18:04:53 [tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_UI_OBJECT_U1) violated


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
References


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