Siebel Production Database Upgrade (upgrep + Upgphys) Fails

(Doc ID 1954733.1)

Last updated on JULY 20, 2016

Applies to:

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

Symptoms

On : 8.1.1.11.12 [IP2013] version, Upgrade

When attempting to run upgrade, you are getting the the following error occurs.

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

Merging table S_LOY_MEM_TIER ...
Granting table S_LOY_MEM_TIER ... 0.009s
Merging table S_LOY_MEM_VCHR ...
Granting table S_LOY_MEM_VCHR ... 0.002s
Merging table S_LOY_MEMBER ...

S0012: [IBM][CLI Driver][DB2/AIX64] SQL0204N "SIEBEL.IDX1301181929440" is an undefined name. SQLSTATE=42704

drop index IDX1301181929440
;
writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
writeExecDDL error (pOperCallback UTLDbDdlOperIndDrop).
Error in MainFunction (UTLDbDdlDbMerge).
Error in Main function...
Errors encountered 1301181929440 ...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Copied schema.ddl and custrep.dat file to TEST environment
2. Ran UpgPhys
3. The above errors are encountered

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, you are unable to proceed with test upgrade

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