Getting Ora-02291: Integrity Constraint Errors Running Grant_all For OFSA 4.5 (Doc ID 284407.1)

Last updated on AUGUST 11, 2009

Applies to:

Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Financial Data Manager - Version: 4.5.33 - 4.5.40
This problem can occur on any platform.

Symptoms

While running Grant_All on the server line, the following errors are displayed:

ERRORS

SQL> set serveroutput on
SQL> execute ofsa_dba.grant_all('OFSA','COMMAND_LINE');
Error during - Write column data
ORA-02291: integrity constraint (SYSOFSA.OFSA_TAB_COLUMNS_FK1) violated - parent key not found
Error during - Write column mls data
ORA-02291: integrity constraint (SYSOFSA.TAB_COLUMNS_MLS_FK) violated - parent key not found
BEGIN ofsa_dba.grant_all('OFSA','COMMAND_LINE'); END;

*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 91
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at "SYSOFSA.OFSA_VIEWS", line 24
ORA-06512: at "SYSOFSA.OFSA_VIEWS", line 136
ORA-06512: at "SYSOFSA.OFSA_DBA", line 78
ORA-06512: at line 1

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