ODI-15005: The Datatype <USER DATATYPE NAME> Does not Exist is Received in ODI 12c when Trying to Journalize a Table in Technology <NAME> (Doc ID 2579736.1)

Last updated on AUGUST 26, 2019

Applies to:

Symptoms

Considering the following table created in a technology <NAME>, and reverse engineered in Oracle Data Integrator (ODI) 12c:

create type <USER DATATYPE NAME> from <A STANDARD DATATYPE NAME> not null ;

create table <TABLE NAME>
(
  <COLUMN 1> <USER DATATYPE NAME> not null,
  <COLUMN 2> <ANOTHER STANDARD DATATYPE NAME>,
  constraint "<PK CONSTRAINT NAME>" primary key ( <COLUMN 1> )
) ;

After having successfully added the table to the CDC, the following message is received on the subscribe step of ODI journalization process:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-15005: The datatype "<USER DATATYPE NAME>" does not exist in technology: <NAME>.
  at com.sunopsis.dwg.codeinterpretor.SnpGenerator.convertDataType(SnpGenerator.java:519)
  at com.sunopsis.dwg.codeinterpretor.SnpGenerator.convDT(SnpGenerator.java:328)
  at com.sunopsis.dwg.codeinterpretor.SnpGenerator.convDT(SnpGenerator.java:303)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorJournalize.updateSnpRef(SnpGeneratorJournalize.java:468)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorJournalize.treatDataStore(SnpGeneratorJournalize.java:1452)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorJournalize.mainGenJrnlDataStoreInternal(SnpGeneratorJournalize.java:133)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorJournalize.mainGenJrnlDataStore(SnpGeneratorJournalize.java:87)
  at com.sunopsis.graphical.dialog.SnpsDialogExecution.doDataStoreJournalize(SnpsDialogExecution.java:446)
  at oracle.odi.ui.action.SnpsPopupActionJrnSubscribeHandler.actionPerformed(SnpsPopupActionJrnSubscribeHandler.java:69)
  at ...

Changes

Cause

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