String Data, Right Truncation With Gateway

(Doc ID 1305506.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 08-Jan-2016

Symptoms



Error occurs when using gateway DG4MSQL 11g:

SELECT "CUSTOMER_ID","CustomerName" FROM "CUSTOMERS"@REMI  WHERE "CUSTOMER_ID"=1806950;
ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}
ORA-02063: preceding 2 lines from REMI

Customer_Name datatype is VARCHAR(100)
In the Oracle database NLS_LANG = UTF-8

Result should be;
CUSTOMER_ID       CustomerName
 ----------------- ----------------------------------------------------------------------------------------------------
1806950
SEGITTUR (SOCIEDAD  PARA LA GESTI�N DE LA INNOVACI�N Y LAS TECNOLOG�AS TUR�STICAS, S. A.)-    ...

Cause

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 hundreds of Community platforms