Database Initialization Failing On New _RX Tables In IP2015 (Doc ID 2024673.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

On : 15.0 [IP2015] version, Remote / Replication / Anywhere

When attempting to run DBinit via Siebel Tools after upgrade from 8.1.1.11 to 15.0,
the following error occurs.

ERROR
-----------------------

SQLError Statement 0 000000025581124c:0 2015-06-17 10:27:38 SQL Statement:
insert into SIEBEL.S_VIEW_RX (CONFLICT_ID,
CREATED,
CREATED_BY,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
INACTIVE_FLG,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
PAR_ROW_ID,
REPOSITORY_ID,
RESPONSIVE_FLG,
ROW_ID) values (?, ?, ?, current utc timestamp, '', ?, ?, ?, ?, ?, ?, ?, ?)

UpgradeLog UpgradeError 1 000000025581124c:0 2015-06-17 10:27:38 [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Index 'S_VIEW_RX_P1' for table 'S_VIEW_RX' would not be unique
UpgradeLog UpgradeError 1 000000025581124c:0 2015-06-17 10:27:38 Unable to import table "S_VIEW_RX" (UTLOdbcExecute insert).
UpgradeLog UpgradeError 1 000000025581124c:0 2015-06-17 10:27:38 Unable to process data file 00000017.dat.
UpgradeLog UpgradeError 1 000000025581124c:0 2015-06-17 10:27:38 Import DML action failed.
UpgradeLog UpgradeError 1 000000025581124c:0 2015-06-17 10:27:38 Error executing action (Importing enterprise data).





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