Upgrading From 4.06 To 5.4 Getting Error On V.05.03.00.00 Script Update In RateManager (Doc ID 2266686.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms

On : Insbridge 5.4.0.0.0 version, RateManager

Upgrading from 4.06 to 5.4 getting error on V.05.03.00.00 script update in RateManager


ERROR
-----------------------
Error executing (v05.03.00.00_2016-10-31T08.00.00_RM): Cannot Execute SQL Command: Invalid column name 'prj'. Invalid column name 'prod'. Invalid column name 'p'. Invalid column name 'l'. Invalid column name 'prj'. Invalid column name 'prod'. Invalid column name 'p'. Invalid column name 'l'.

Then when I try to run it directly on the SQL Server I get this error.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 224
Invalid column name 'prj'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 225
Invalid column name 'prod'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 226
Invalid column name 'p'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 227
Invalid column name 'l'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 238
Invalid column name 'prj'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 239
Invalid column name 'prod'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 240
Invalid column name 'p'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_GET_VALIDVALUE, Line 241
Invalid column name 'l'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_VALIDVALUE_EXISTS, Line 287
Invalid column name 'prj'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_VALIDVALUE_EXISTS, Line 288
Invalid column name 'prod'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_VALIDVALUE_EXISTS, Line 289
Invalid column name 'p'.
Msg 207, Level 16, State 1, Procedure ufn_Q_RM_VALIDVALUE_EXISTS, Line 290
Invalid column name 'l'.
Msg 102, Level 15, State 1, Procedure usp_I_RM_TEMPLATE_PROCESS_CREATE_PROGRAM_ITEM, Line 25227
Incorrect syntax near ')'.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Ratemanager go to Tools=>Database=>Updates
2. View error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update 4.6 version RM database to 5.4..

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