OFSAA Model Upload Fails with 1 >= 1 Message (Doc ID 1343265.1)

Last updated on JANUARY 23, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you try to upload an Erwin Data Model that is a merge of multiple models, the Model Upload fails with the following in the log file:

----------------------------------------------
fsi_exchange_rate_hist

1 >= 1
----------------------------------------------
MODEL UPLOAD FAILED.
----------------------------------------------

If you review the nohup.out file in $FIC_APP_HOME/common/FICServer/bin or the Java Console on your computer, you see the following error:

java.lang.ArrayIndexOutOfBoundsException: 1 >= 1
        at java.util.Vector.elementAt(Vector.java:427)
        at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.keyFBascolCmp(ClsUCntUploadModel.java:1533)
        at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.AlterModifyTable(ClsUCntUploadModel.java:3231)
        at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.handleRequest(ClsUCntUploadModel.java:259)
        at com.iflex.fic.etl.UploadModel.cnt.ClsUCntErwinUpLoad.uploadErwin(ClsUCntErwinUpLoad.java:160)
        at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:222)
        at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:133)
        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:296)
        at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
        at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:202)
ERWINUPLOAD Altering the Model Failed.

The error prevents you from loading their new merged Data Model.

Steps to Reproduce:
  1. Go to Unified Metadata Manager > Import Model
  2. Select the merged Data Model from the list
  3. Click Upload
The model upload fails.

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