My Oracle Support Banner

5.6.0 Install Issue - DB Update Script, V05.06.00.00, Fails (Doc ID 2705551.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 5.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 5.6.0.0.0 version, RateManager

5.6.0 Install Issue - DB Update Script, v05.06.00.00, fails

Installed RateManager 5.6.0 and tried to run DB update scripts. Before the install IBRM status is at v05.02.00.00. After installing 5.6.0, we are able to execute update scripts v05.03.00.00, v05.04.00.00, v05.05.00.00 for IBRM without any issues. When we tried to run v05.06.00.00 are getting error.

ERROR
-----------------------
Message

Error executing (SCHEMA_CHANGES): Cannot Execute SQL Command: The index 'idx_PgmCalcVars_PrjModlID' is dependent on column 'Prog_Ver'.

Alter Tabvle Alter Column Prog_Ver ailed because one or more objects access this column.

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.