IRM: ORA-30556: "either functional or bitmap join index is defined on the column to be modified" for a Siebel upgrade from 8.1.1.10 to 8.1.1.11 (Doc ID 1601564.1)

Last updated on JULY 20, 2016

Applies to:

Siebel eMedia - Version 8.1.1.9 [23016] and later
Siebel System Software - Version 8.1.1.9 [23016] and later
Siebel CRM - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

Environment
===========

Siebel CRM version 8.1.1.11/ Oracle 11g

Applicable to MS SQL 2008 also

Description
============

During the Siebel upgrade from V8.1.1.10 to V8.1.1.11 - i.e. while running Incremental Repository Merge, the following error is reported in ddlctl_tab.log file.

2013-11-03 22:12:07 SQL Statement:
alter table S_CONTACT modify
"EMAIL_ADDR" varchar2(350 char)
2013-11-03 22:12:07 [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified

2013-11-03 22:12:07
2013-11-03 22:12:07 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2013-11-03 22:12:07
2013-11-03 22:12:07 alter table S_CONTACT modify
2013-11-03 22:12:07 "EMAIL_ADDR" varchar2(350 char)
2013-11-03 22:12:07
2013-11-03 22:12:07 ;
2013-11-03 22:12:07 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2013-11-03 22:12:07 writeExecDDL error (UTLDbDdlColModify).
2013-11-03 22:12:07 Error in MainFunction (UTLDbDdlDbMerge).
2013-11-03 22:12:07 Error in Main function...
2013-11-03 22:12:07 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

Impact
==========

Dev upgrade is halted because of this error

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