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 DECEMBER 18, 2019

Applies to:

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

Symptoms

When attempting to start CDC (journalization) in 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): 

8152: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated.

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
References

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