My Oracle Support Banner

'Data conversion or data mapping error' When Executing Integration Interface with DB2/400 as Source in ODI (Doc ID 424205.1)

Last updated on DECEMBER 20, 2019

Applies to:

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

Symptoms

Case 1. Numeric columns of type Number(x,y) are set to 0

In Oracle Data Integrator (ODI) Designer, when right click and select view data on an AS/400 v5 Source Datastore containing numeric columns of type Number(21,8), it appears that all values are set to 0 -- which is incorrect.

Case 2. Columns are shown as "Unsupported" or "Unsupported image format"

In Oracle Data Integrator (ODI) Designer, when right click and select view data on an AS/400 v5 Source Datastore, all of the fields are shown as "Unsupported" or "Unsupported image format", except a couple of text columns.

Case 3. Receiving [SQL0802] Data conversion or data mapping error

The following message is displayed when executing an Oracle Data Integrator (ODI) Integration Interface:

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
 Case 1. Numeric columns of type Number(x,y) are set to 0
 Case 2. Columns are shown as "Unsupported" or "Unsupported image format"
 Case 3. Receiving [SQL0802] Data conversion or data mapping error
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.