My Oracle Support Banner

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:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution
References


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