My Oracle Support Banner

'data type conversion not possible' Message when Loading Date Fields into Sybase IQ Tables with ODI (Sunopsis) Integration Interfaces (Doc ID 424281.1)

Last updated on NOVEMBER 29, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.

Symptoms

When using an Oracle Data Integrator (ODI) (Sunopsis) Integration Interface to load data from a text file into a Sybase IQ Datastore, the following message is signaled concerning the date fields:

The Sybase IQ "CONVERT(DATETIME,<column expression>)" function is being used for the File date columns.

What is wrong here?

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!

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