My Oracle Support Banner

'String or binary data would be truncated' When Validating An Update To An ODI Integration Interface Using Spanish (Doc ID 974251.1)

Last updated on JUNE 16, 2022

Applies to:

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

Symptoms

When attempting to open and update an Integration Interface in an ODI version 10.1.3.5.4 configuration in Spanish using the following odiparams options for GUI languages :

set ODI_ADDITIONAL_JAVA_OPTIONS="-Duser.language=es" "-Duser.region=ES"

The following message is signaled :

com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

It is noticed  if the default (English version) is used with Java with no language options set with the ODI_ADDITIONAL_JAVA_OPTIONS parameter, then this problem does not occur.

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.