My Oracle Support Banner

'String or binary data would be truncated' Message with Multibyte Character Databases when Using CDC Feature of ODI (Doc ID 424196.1)

Last updated on NOVEMBER 30, 2023

Applies to:

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

Symptoms

When attempting to start CDC (journalization) in Oracle Data Integrator (ODI) on a table of a multibyte character RDBMS instance, the "Create Subscribers Table" step hangs (the green active icon for this task leads us to believe that it is still running).

In fact, the overall session does not remain in a suspended state but fails (indicated by the stop sign icon).

A message which is signaled to be independent of any step is displayed in the session "Execution" tab of the session summary.

In the case of Microsoft SQLServer the following message is displayed (analogous messages will be displayed with other RDBMSs): 

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.