Sliced Model Upload Fails with 'Merging of sliced model failed..java.lang.NullPointerException' (Doc ID 2289234.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Analytical Applications (OFSAA) 8.0.4, when you try to re-run a Sliced Data Model Upload after getting an Object Registration error, the upload fails and the model upload log from /<ftpshare>/<Infodom>/erwin/logs contains nothing after the following lines:

STARTED MERGING THE DATABASE MODEL FILE FOR SLICED MODEL UPLOAD AT Mon Jul 03 14:51:24 EDT 2017
ERWINUPLOAD ERROR..Model Upload Failed while handling Sliced Merge

Before this model upload, you had run another model upload that failed during the Object Registration step.
(For example, object registration failed with ORA-02292: integrity constraint (OFSAAATM.FK_REV_TAB_CONST_COLUMNS) violated - child record found))

Now, after addressing the object registration issue, when you run the model upload again, it fails during the model upload step.

You find messages and errors like the following in the ETLService.log from $FIC_APP_HOME/common/FICServer/logs:

[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]slicedTableVersion:80400:baseTableVersion:80400
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]Table already present in previous datamodel xml ::DIM_DATES
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]base tables map is not null
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]slicedTableVersion:80400:baseTableVersion:80400
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]Table already present in previous datamodel xml ::DIM_CURRENCY
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]base tables map is not null
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]slicedTableVersion:80400:baseTableVersion:80400
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]Table already present in previous datamodel xml ::DIM_RUN
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]base tables map is not null
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]slicedTableVersion:80400:baseTableVersion:null
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]Table already present in previous datamodel xml ::FCT_AGG_BASE_CCY_IRR_GAP
[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]
java.lang.NullPointerException
       at com.iflex.fic.etl.UploadModel.cnt.DataBaseModelReWriter.mergeSlicedModel(DataBaseModelReWriter.java:181)
       at com.iflex.fic.etl.UploadModel.cnt.DataBaseModelReWriter.mergeSlicedModelAndSave(DataBaseModelReWriter.java:104)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntDeltaTransformation.handleDeltaTransformation(ClsUCntDeltaTransformation.java:62)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntErwinUpLoad.uploadErwin(ClsUCntErwinUpLoad.java:152)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:587)
       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:297)
       at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
       at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:201)

[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]Error during mering of sliced model...java.lang.NullPointerException

and

[ETLLOG] Jul 5,17 11:31:36 : [DATABASEMODELREWRITER]Merging of sliced model failed..java.lang.NullPointerException
[ETLLOG] Jul 5,17 11:31:36 : [CLSUCNTDELTATRANSFORMATION]Error while rewriting DATABASE xml for sliced model upload
[ETLLOG] Jul 5,17 11:31:36 : [MODELUPLOADHELPER]Log Message::::Model Upload Failed while handling Sliced Merge

These errors cause the model upload to fail.

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