Last updated on JULY 25, 2017

Applies to:

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