OBP CONNECTORS PUBLISH IS FAILING DUE TO SPACE IN DATATYPES

(Doc ID 2311623.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.4 to 8.0.5 [Release 8]
Information in this document applies to any platform.

Symptoms

 OBP connectors publish is failing with the following error stack trace in DIH.log.

[20-09-17 10:40:54 AM] ~ INFO ~ DIHLOGGER ~ [ODIMapping][buildDataStores]Datatype of [ORG_UNIT_CODE]-->VARCHAR2
[20-09-17 10:40:54 AM] ~ INFO ~ DIHLOGGER ~ [ODIMapping][buildDataStores]ODI datatype not found for column:ORG_UNIT_CODE: with datatype:VARCHAR2 :for Technology:ORACLE
[20-09-17 10:40:54 AM] ~ INFO ~ DIHLOGGER ~ [RegisterAction][publishConnector]Error ocurred while publishing connector ---
[20-09-17 10:40:54 AM] ~ ERROR ~ DIHLOGGER ~ Datastore creation in ODI failed
java.lang.Exception: Datastore creation in ODI failed
at com.ofs.reveleus.DIH.model.ODIMapping.buildDataStores(ODIMapping.java:530)
at com.ofs.reveleus.DIH.action.RegisterAction.publishConnector(RegisterAction.java:9144)
at com.ofs.reveleus.DIH.action.RegisterAction.saveConnector(RegisterAction.java:8180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused by: java.lang.Exception: Unsupported Datatype [VARCHAR2 ] for Technology:ORACLE
at com.ofs.reveleus.DIH.model.ODIMapping.buildDataStores(ODIMapping.java:332)

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