My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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 (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

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
Cause
Solution


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