Encounter java.lang.NullPointerException Error When Publishing DIH Connectors (Doc ID 2151446.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Data Integration Hub (DIH)

Symptoms

On Oracle Financial Services Data Integration Hub (DIH) 8.0.2, when attempting to publishing DIH connectors, the following error occurs on UI.

ERROR
"java.lang.NullPointerException" 

Besides above, in the ETLService.log, the following error also appears:

[ETLLOG] Jun 16,16 19:09:21 : [DATABASEMODELREWRITER]Error during mering of sliced model...java.lang.NullPointerException
[ETLLOG] Jun 16,16 19:09:21 : [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:580)
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] Jun 16,16 19:09:21 : [DATABASEMODELREWRITER]Merging of sliced model failed..java.lang.NullPointerException
[ETLLOG] Jun 16,16 19:09:21 : [CLSUCNTDELTATRANSFORMATION]Error while rewriting DATABASE xml for sliced model upload
[ETLLOG] Jun 16,16 19:09:21 : [MODELUPLOADHELPER]Log Message::::Model Upload Failed while handling Sliced Merge

The issue can be reproduced at will with the following steps:
1. Did all necessary steps & uploaded the model using slice mode in DIH for custom tables, it was uploaded successfully. Tables were created properly in database.
2. Then refreshed ADI and observed that all those custom tables were reflected in DIH.
3. Then created connectors for those DIH custom tables.
4. Publish DIH connectors

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