In Siebel Version 23.* During Schema Migration from DR to RR Error Message, "ORA-30556: either functional or bitmap join index is defined on the column to be modified" Is Being Displayed
(Doc ID 2980155.1)
Last updated on DECEMBER 04, 2023
Applies to:
Siebel CRM - Version 23.8 and laterInformation in this document applies to any platform.
Symptoms
After applying Siebel patch from 23.2 to 23.8 version, running Repository Upgrade while performing schema migration with REST API from DR to RR into "dboutput.log" the following error occurs:
ERROR
-----------------------
ORA-30556: either functional or bitmap join index is defined on the column to be modified
In current scenario it was found that before importing new schema into "pre_schema.sql" file a SQL statement pre-step was running:
- DROP INDEX S_CL_SUBJ_LS_U1
This was pointing to SQL statement "alter table S_CL_SUBJ_LS modify SUBJ_INITL varchar2(30 char);" that couldn't run during Siebel Repository Upgrade.
The behavior was reported only in development environment and not in runtime repository.
Changes
Siebel patch was applied from version 23.2 to 23.8.
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 |