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