Siebel 8.1.1.11 IRM - Siebel Database Configuration Wizard Fails With Error ORA-30556

(Doc ID 1622613.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel Public Sector Call Center - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Running Siebel upgrade from version 8.1.1.7 SIA to 8.1.1.11  in the Development environment.

When running the Upgrade - Upgrep process, at the Step "Run the Siebel Database Configuration Wizard under WIndows" , it errors out with the following :

2013-11-06 15:09:31 SQL Statement:
alter table S_CONTACT modify
"EMAIL_ADDR" varchar2(350 char)

2013-11-06 15:09:31 [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2013-11-06 15:09:31
2013-11-06 15:09:31 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2013-11-06 15:09:31
2013-11-06 15:09:31 alter table S_CONTACT modify
2013-11-06 15:09:31 "EMAIL_ADDR" varchar2(350 char)

In 8.1.1.7 version, case insensitivity search is configured on the S_CONTACT.EMAIL_ADDR field .

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