ODBC Error in reading data from Oracle Table

[rawat_ashish]

Hi,

We are trying to connect Oracle database tables which have recently upgraded to SSL. We needed to use Oracle Wire Protocol Driver to accommodate change (See attachment from ODBC Administrator) as it has SSL options. We are making successful connection while manual test on the ODBC Administrator on both 32-bit and 64-bit connection so, it looks that settings are fine.

We are having actual issue when we run the Dataflux in our application's data-processing. It is creating session-id however, it is giving error on multiple oracle tables like “[9:ODBC_PARAM_QUERY:READ Employee_Info] [22001] [DataFlux][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 1. (0)”

(Here 'Employee_Info' is an oracle table name)

Has anyone faced such error in SSL implementation? 

We are using Oracle version 12.2.0 and Dataflux version 2.8. Any suggestion will be appreciated. Thanks!!

[JosvanderVelden]

Have a look at the "Enable N-CHAR Support" paragraph on this page https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.9/Content/dfDMStd_T_DSN_Usage.html
Do you think this applies to your environment?

[rawat_ashish]

Thanks for the reply. I have tried it and restarted the server but error is still coming up when we run the process from application.

[rawat_ashish · Accepted solution]

Enabling DSN Settings helped:

•   Application using threads
•   Catalog Options
•   Enable SQLDescribeParam
•   Procedure Returns Results
•   Describe at Prepare

It was suggested by Dataflux SAS support. Marking this as resolved now. Thanks!!