My Oracle Support Banner

DIH 8.1: Precision As Per EDD Throws Error In DIH /ODI (Doc ID 2818215.1)

Last updated on NOVEMBER 05, 2021

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

on DIH 8101 version:

Create a F2T connector wherein the target table column precision is more than the one defined in EDD.

Example: if the target column precision is 3 but in the EDD the precision is set to 1

Connector fails with the below error:

Error msg -
oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLException: ODI-40435: Could not transform data for column <Column name> value <column value> because: Too many decimals: <column value> has more than <x> decimals.

Note :<Column Name> is the target table column name, <Column Value> is the decimal value that is causing the issue and <x> is the number that should be added in column precision value of the EDD.

Changes

 DIH was upgraded from 803 to 8.1 version

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


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