Cannot Run Reporting Database Script (Doc ID 2256379.1)

Last updated on APRIL 20, 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

Cannot run Reporting Database Script

We are trying to setup Insbridge 5.4 in a test environment. We get an error when we try to execute the db script for the Reporting database (see attachments). We restored the IBRM template for 2008 SQL Server provided by Oracle (in product download pack) and ran IBRM scripts then tried running the Reporting database scripts.

ERROR
-----------------------
Error executing (SCHEMA_CHANGES): Cannot Execute SQL Command: Ambiguous coumn name 'PROGRAQM)ID'. ORDER BY items must appear in the select list if SELECT DISTINCT is specified.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a. Install Insbridge 5.4;
b. Restore IBRM template for SQL Server 2008 (non-case sensitive);
c. Open RateManager and run IBRM and IB Client scripts;
d. Try running Reporting database scripts.

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

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