Siebel 22.1 And Later Upgrep Fails With "ORA-30556: either functional or bitmap join index is defined on the column to be modified" Error For S_CL_SUBJ_LS Table
(Doc ID 2870360.1)
Last updated on AUGUST 08, 2023
Applies to:
Siebel CRM - Version 22.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to execute upgrade to Siebel version 22.1 and later, the upgrep step fails and the following error occurs in the ddlctl_tab.log:
2022-05-09 12:04:49 D:\SIEBEL\siebsrvr\bin\ddlimp.exe /u siebel /p ***** /c Upgrade /f D:\SIEBEL\dbsrvr/oracle/ddl.ctl /t y /i n /e y /B SIEBEL /X SIEBEL_INDEX /G SSE_ROLE /R Y /l D:\SIEBEL\siebsrvr\log\upgrep_dev_155\output/ddlctl_tab.log /W Y
2022-05-09 12:04:49
2022-05-09 12:04:49 Connecting to the database...
...
2022-05-09 12:07:28 Merging table S_CL_SUBJ_LS ...
2022-05-09 12:07:28 SQL Statement:
alter table S_CL_SUBJ_LS modify
"SUBJ_INITL" varchar2(30 char)
2022-05-09 12:07:28 [tp][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2022-05-09 12:07:28
2022-05-09 12:07:28 S1000: [tp][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2022-05-09 12:07:28
2022-05-09 12:07:28 alter table S_CL_SUBJ_LS modify
2022-05-09 12:07:28 "SUBJ_INITL" varchar2(30 char)
2022-05-09 12:07:28
2022-05-09 12:07:28 ;
2022-05-09 12:07:28 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2022-05-09 12:07:28 writeExecDDL error (UTLDbDdlColModify).
2022-05-09 12:07:28 Error in MainFunction (UTLDbDdlDbMerge).
2022-05-09 12:04:49
2022-05-09 12:04:49 Connecting to the database...
...
2022-05-09 12:07:28 Merging table S_CL_SUBJ_LS ...
2022-05-09 12:07:28 SQL Statement:
alter table S_CL_SUBJ_LS modify
"SUBJ_INITL" varchar2(30 char)
2022-05-09 12:07:28 [tp][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2022-05-09 12:07:28
2022-05-09 12:07:28 S1000: [tp][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2022-05-09 12:07:28
2022-05-09 12:07:28 alter table S_CL_SUBJ_LS modify
2022-05-09 12:07:28 "SUBJ_INITL" varchar2(30 char)
2022-05-09 12:07:28
2022-05-09 12:07:28 ;
2022-05-09 12:07:28 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2022-05-09 12:07:28 writeExecDDL error (UTLDbDdlColModify).
2022-05-09 12:07:28 Error in MainFunction (UTLDbDdlDbMerge).
The issue can be reproduced at will with the following steps:
1. Perform upgrade to 22.1 or later
2. Execute upgrep
3. Check to see if upgrep is successfully executed
Changes
Perform upgrade/IRM to 22.1 or later
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 |