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 JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When using an 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!


In this Document
Symptoms
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.