topic ODBC Error in reading data from Oracle Table in Administration and Deployment

ODBC Error in reading data from Oracle Table

rawat_ashish — Fri, 20 Oct 2023 15:15:44 GMT

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!!

Re: ODBC Error in reading data from Oracle Table

JosvanderVelden — Mon, 23 Oct 2023 09:08:52 GMT

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?

Re: ODBC Error in reading data from Oracle Table

rawat_ashish — Mon, 23 Oct 2023 12:20:13 GMT

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.

Re: ODBC Error in reading data from Oracle Table

rawat_ashish — Fri, 27 Oct 2023 15:41:56 GMT

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!!