My Oracle Support Banner

IFRS 8.0.7 Installation Failing With "[ERROR] Error in Model upload. So aborting installation" (Doc ID 2731441.1)

Last updated on FEBRUARY 24, 2023

Applies to:

Oracle Financial Services Hedge Management and IFRS Valuations - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

While installing IFRS 8.0.7, released Model upload fails with the following errors in OFS_IFRS_installation.log:

[17-10-20 10:30:43,449 PKT AM] [INFO ] Model upload status message : [123] Error in Upload Operation
[17-10-20 10:30:43,449 PKT AM] [INFO ] Model upload log : <FTPSHARE Location>/OFSERMINFO_LOG_XXX.log
[17-10-20 10:30:43,450 PKT AM] [ERROR] Error in Model upload. So aborting installation

Alon with this error below can be found in Data Model related logs:

In Data Model upload log: <FTPSHARE Location>/OFSERMINFO_LOG_XXX.log:

......................
Fct_Mitigants.

This column F_HEDGE_FLAG has been deleted from the table FCT_MITIGANTS in the new database model 

 This column F_HEDGE_FLAG of table FCT_MITIGANTS has been used in Dataset definitions, <DATASET NAME> and hence cannot be dropped.
 Dataset Name: <DATASET NAME>, Dataset Description: <DATASET DESCRIPTION>

 

In ETLService.log from Applayer location:

[17-10-20 06:53:47,629 GMT AM] [DEBUG] [APP] [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::Started Validating Deleted Tables and Creating Drop Table Scripts
[17-10-20 06:53:55,231 GMT AM] [DEBUG] [APP] [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::This column F_HEDGE_FLAG of table FCT_MITIGANTS has been used in Dataset definitions, <DATASET NAME>and hence cannot be dropped.
[17-10-20 06:54:00,292 GMT AM] [DEBUG] [APP] [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::Error - Metadata Mapping is Present for Tables, so cannot Drop
.......................
[17-10-20 06:54:00,323 GMT AM] [DEBUG] [APP] [ETL]  [NA] [CLSUCNTUPLOADHANDLER] [ETL Upload Model]String returned by Model Upload Model Upload Failed
[17-10-20 06:54:00,323 GMT AM] [DEBUG] [APP] [ETL]  [NA] [MODELUPLOADHELPER] Log Message::::Error in Model Upload.
[17-10-20 06:54:00,326 GMT AM] [ERROR] [APP] [ETL]  [NA] [CLSUCNTUPLOADHANDLER] 
com.iflex.fic.etl.UploadModel.cnt.ModelUploadException
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(Unknown Source)
at com.iflex.fic.metadata.services.ModelUploadServiceProvider.handleRequest(Unknown Source)
at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:299)
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:206)
[17-10-20 06:54:00,326 GMT AM] [DEBUG] [APP] [ETL]  [NA] [CLSUCNTUPLOADHANDLER] [ETL Upload Model]Error in Model Upload.
[17-10-20 06:54:00,329 GMT AM] [DEBUG] [APP] [ETL]  [NA] [MODELUPLOADHELPER] Query IS::::UPDATE REV_MODEL_UPLOAD SET STATUS='Failed' WHERE MODEL_ID=202119

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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