OFSAA Model Upload Hangs Instead of Completing With Failure (Doc ID 2165780.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Oracle Financial Services Profitability Management - Version 8.0.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Symptoms

On OFSAAI 8.0.2 the model upload is hanging with the following errors:

ERROR
From the $FIC_APP_HOME/common/FICServer/nohup.out:

Successfully executed
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "CAPITAL_CHARGE": invalid identifier
Successfully executed
Successfully executed

...

Successfully executed
Successfully executed
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "ACH_INTERNAL_FLAG": invalid identifier
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "COFF_AMT": invalid identifier
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "COFF_DATE": invalid identifier
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "COMMITMENT_END_DATE": invalid identifier
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "LAST_PAYMENT_REC_AMT": invalid identifier
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "MAIL_ADDR": invalid identifier
Error is......Error while Executing Bind variables query :Error Executing Query. Error: ORA-00904: "MAIL_STATE": invalid identifier
[26-05-16 14:36:57,640 PM]~[DEBUG]~Performing cache cleanup.
[26-05-16 14:46:57,640 PM]~[DEBUG]~Performing cache cleanup.

The model upload log ends abruptly:

FSI_D_LOAN_CONTRACTS.

This column AF_USAGE has been deleted from the table FSI_D_LOAN_CONTRACTS in the new database model

This column BILLING_DEFINITION_CD has been deleted from the table FSI_D_LOAN_CONTRACTS in the new database model

This column CAPITAL_CHARGE has

The SMSService.log with debug on shows a few errors like the following:
[UMMLOG] May 27,16 13:00:33 : [DACDATABASEGATEWAY]Failed Executing 2nd time normal Select Query : [SELECT count(1) FROM FSI_D_LOAN_CONTRACTS where mail_state is not null ] [On URL: jdbc:oracle:thin:@prodora337l:1541/pqfih] [Driver: oracle.jdbc.driver.OracleDriver] [Metadata Required : false]
[UMMLOG] May 27,16 13:00:33 : [DACDATABASEGATEWAY]
java.sql.SQLSyntaxErrorException: ORA-00904: "MAIL_STATE": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

The issue can be reproduced at will with the following steps:
1. Run Incremental Model upload with more than 10 columns already dropped in the database (which model upload is trying to drop).
2. Find model upload hangs and does not FAIL as expected.

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