Error "ORA-30556: either functional or bitmap join index is defined on the column to be modified" While Performing Siebel Version Upgrade
(Doc ID 1601564.1)
Last updated on APRIL 18, 2023
Applies to:
Siebel System Software - Version 17.0 [IP2017] and laterSiebel eMedia - Version 17.0 [IP2017] and later
Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.
Symptoms
During the Siebel upgrade, 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)
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)
This is applicable to both Oracle and MS SQL Server databases.
Changes
Issue coming while performing the Siebel version Upgrade
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 |