Siebel Production Database Upgrade (upgrep + Upgphys) Fails

(Doc ID 1954733.1)

Last updated on JULY 20, 2016

Applies to:

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


On : [IP2013] version, Upgrade

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


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 ...

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

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


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