My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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.


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


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


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

Checked for relevance on 11-Aug-2009.

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