Failed to Execute Query Errors for CREATE TABLE Statements in OFSAA 7.2 ConfigReveleus.log (Doc ID 1298610.1)

Last updated on MARCH 14, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 7.2

Symptoms

When installing Oracle Financial Services Analytical Applications (OFSAA) 7.2, you get many errors in the configReveleus.log.  Below is an example of the errors:

[Thu 16/12/2010 11:06:26] [Reveleus] [ERROR]:-Failed to execute the Query : CREATE TABLE TAB_MASTER
(
TAB_ID NUMBER NOT NULL ENABLE,
TAB_FORM_PARAMETERS VARCHAR2(3000 ),
ISFORM VARCHAR2(1 ),
TA.....
[Thu 16/12/2010 11:06:26] [Reveleus] [WARN] :-Failed to execute query..
[Thu 16/12/2010 11:06:26] [Reveleus] [ERROR]:-Failed to execute the Query : CREATE TABLE TAB_DISPLAY_FILTERS
(
SET_ID NUMBER NOT NULL ENABLE,
TAB_ID NUMBER NOT NULL ENABLE,
PARAM_NAME VARCHAR2(3000 ) NOT NULL ENABLE,
PARAM_VALUE VARCHAR2(3000 ),
DSN_ID VARCHAR2(50 ) NOT NULL ENA.....
[Thu 16/12/2010 11:06:26] [Reveleus] [WARN] :-Failed to execute query..
[Thu 16/12/2010 11:06:26] [Reveleus] [WARN] :-Commit to the DataBase failed
[Thu 16/12/2010 11:06:26] [Reveleus] [ERROR]:-Failed to execute the Query : CREATE TABLE TAB_FUNCTION_MAP
(
TAB_ID NUMBER NOT NULL ENABLE,
FUNCTION_CODE VARCHAR2(100 ) NOT NULL ENABLE,
DSN_ID VARCHAR2(50 ) NOT NULL ENABLE,
CONSTRAINT PK_TAB_FUNC.....
[Thu 16/12/2010 11:06:26] [Reveleus] [WARN] :-Failed to execute query..
[Thu 16/12/2010 11:06:26] [Reveleus] [WARN] :-Commit to the DataBase failed

The errors occur for the following scripts:

create_grctabs.sql
create_grcLandingPage.sql
create_pr2.sql
insert_pr2.sql
create_modeling_fw.sql
insert_icc_model.sql
create_opt.sql
create_pool.sql
create_stresstesting_fw.sql
insert_variable_configuration_master.sql
create_portal.sql
create_fif.sql
drop_unlicenced.sql

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