Data Model Upload Fails With 'Error While Executing the Scripts' But No Specific Error Listed (Doc ID 2400758.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

When doing a new install of the Oracle Financial Services Profitability Management (PFT) Pack 8.0.5, the install fails during the model upload step without providing a specific error.  The errors below exist in various logs:

Pack_Install.log in /OFS_PFT_PACK/logs:

[Tue 15/5/2018 01:53:44] [WRAPPERINSTALLER] [ERROR] - Error : APP Setup bin file failed. 

OFS_PFT_installation.log in /OFS_PFT_PACK/OFS_PFT/logs:

[Tue 15/5/2018 01:42:21] [OFS_PFT] [ INFO] - Uploading Data model
[Tue 15/5/2018 01:53:35] [OFS_PFT] [ INFO] - [Model Upload]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:null[Ljava.lang.String;@5817f1ca]
[Tue 15/5/2018 01:53:35] [OFS_PFT] [ INFO] - After uploading....
[Tue 15/5/2018 01:53:35] [OFS_PFT] [ INFO] - Model upload status message : [123] Error in Upload Operation
[Tue 15/5/2018 01:53:35] [OFS_PFT] [ INFO] - Model upload log : /<ftpshare>/logs/OFSALMINFO_LOG_1_05.15.2018-01.42.21.log
[Tue 15/5/2018 01:53:35] [OFS_PFT] [ERROR] - Error in Model upload. So aborting installation

Model Upload log from /<ftpshare>/<infodom>/logs:

----------------------------------------------
STARTED CREATING TABLES
----------------------------------------------
Started creating table dim_financial_elements_attr
null
Inside the Rollback Segment
Number of Exec Statements = 0
----------------------------------------------
MODEL UPLOAD FAILED.
----------------------------------------------

ETLService.log from $FIC_APP_HOME/common/FICServer/logs:

[ETLLOG] May 15,18 14:38:33 : [MODELUPLOADHELPER]Log Message::::Starting to Execute the Scripts
[ETLLOG] May 15,18 14:38:33 : [CLSUCNTUPLOADHANDLER]Erwin Complete path.../<ftpshare>/<INFODOM>/erwin/
[ETLLOG] May 15,18 14:38:35 : [MODELUPLOADHELPER]Log Message::::Error While Executing the Scripts
[ETLLOG] May 15,18 14:38:35 : [CLSUCNTUPLOADHANDLER]logFileName:/<ftpshare>/logs/<INFODOM>_LOG_1_05.15.2018-02.27.31.log
[ETLLOG] May 15,18 14:38:35 : [MODELUPLOADHELPER]Query IS::::UPDATE REV_MODEL_UPLOAD SET LOG='/<ftpshare>/logs/<INFODOM>_LOG_1_05.15.2018-02.27.31.log' WHERE MODEL_ID=200001
[ETLLOG] May 15,18 14:38:35 : [MODELUPLOADHELPER]Output..[SC:10][ST:2][SST:0][Oper:0][Version:0][EF:false][D:<INFODOM>][S:null][U:null][PT:2][P:null1]
[ETLLOG] May 15,18 14:38:35 : [CLSUCNTUPLOADHANDLER][ETL Upload Model]String returned by Model Upload Model Upload Failed
[ETLLOG] May 15,18 14:38:35 : [MODELUPLOADHELPER]Log Message::::Error in Model Upload.
[ETLLOG] May 15,18 14:38:35 : [CLSUCNTUPLOADHANDLER]
com.iflex.fic.etl.UploadModel.cnt.ModelUploadException
        at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:619)
        at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:134)
        at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
        at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:211)
        at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:297)
        at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
        at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:201)

[ETLLOG] May 15,18 14:38:35 : [CLSUCNTUPLOADHANDLER][ETL Upload Model]Error in Model Upload.

Note: There is no nohup.out in $FIC_APP_HOME/common/FICServer/bin.

Cause

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