Internal Error, ORA-03113, ORA-01041 & ORA-03114 Running Risk Manager Process (Doc ID 356455.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Risk Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5

Symptoms

When running a Risk Manager (RM) 4.5 process with the "Transform Result Table" box on the "Process Mode" page checked, the following errors occur in the ofsrm.xxxxx file in the $OFSA_HOME/log directory:

Running RM, Process ID: 104119 Configuration ID: 103634
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-03113: end-of-file on communication channel

Driver Function: drv_oci::Execute()

SQL Statement: BEGIN
OFSA_SQL.IA_CREATE_TABLE('OFSAOWNER',104119,0,104119,'RES_DTL_104119','','ORG_UNIT_ID,RM_COA_ID,SCENARIO_
UM,RESULT_TYPE_CD,ISO_CURRENCY_CD',61,'OFS_RPT_RES_DTL_104119_C','60,80,100,120,140,160,210,211,230
430,440,465,485,500',14); END;
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [16] - oclose()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-01041: internal error. hostdef extension doesn't exist

Driver Function: drv_oci::EndSQL

SQL Statement: BEGIN
OFSA_SQL.IA_CREATE_TABLE('OFSAOWNER',104119,0,104119,'RES_DTL_104119','','ORG_UNIT_ID,RM_COA_ID,SCENARIO_
UM,RESULT_TYPE_CD,ISO_CURRENCY_CD',61,'OFS_RPT_RES_DTL_104119_C','60,80,100,120,140,160,210,211,230
430,440,465,485,500',14); END;
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-03114: not connected to ORACLE


Additionally, the following error appears in the database's alert.log:

ORA-07445: exception encountered: core dump

As a result, the Risk Manager process ends with an "Internal Error".

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