My Oracle Support Banner

'311 : ZZZZZ : com.sybase.jdbc2.jdbc.SybSQLException' Message Signaled in an ODI Integration Interface with Sybase Jconnect JDBC Driver (Doc ID 423985.1)

Last updated on DECEMBER 08, 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

An Oracle Data Integrator (ODI) Integration Interface includes 2 Source Datastores, one of which is a lookup table. A filter is set on the lookup Datastore and a simple join is inserted between the 2 Datastores.

When the Loading KM runs, the generated SQL instruction appears to be applying the filter to the reference Datastore. However, the instruction fails with the following message:

When running the SQL instruction directly against the Datastore it works correctly.

Is it mandatory to create an index on the lookup table?

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.