topic Configurable ODBC for DSC throwing Oracle truncate error in QlikView

Configurable ODBC for DSC throwing Oracle truncate error

mdecaro — Mon, 26 Jan 2026 18:19:17 GMT

Trying to create a new Configurable ODBC connection in the Directory Service Connector. A new Oracle database has QV_USERS and QV_USERGROUP materialized views we need to use for customer authorization. These are exact copies from the previous database, also Oracle.

The 2 databases are both Oracle 12 C (current is version 12.1.0.2.0, new is version 12.2.0.1.0). In trying to have user authorization read from the new connection, our ODBC connection throws an Oracle error -- "ORA-01406 fetched column value was truncated."

We were explicitly putting in the following values in the Directory Service Connector's Configurable ODBC:

- table db name

- groups table db name

- override connection string

As well as using the ODBC connection setup on the server on which the DSC was running.

Re: Configurable ODBC for DSC throwing Oracle truncate error

Miguel_Angel_Baeyens — Wed, 21 Aug 2019 14:25:44 GMT

If you read that data from a SQL query using a query browser, or loading data into QlikView, does the error appear for those tables?
Additionally, here you are some Qlik Community posts with similar issues:
https://community.qlik.com/t5/QlikView-App-Development/QV-64-vs-QB-32-bit-problems-in-SQL-Selec/td-p/151145

Re: Configurable ODBC for DSC throwing Oracle truncate error

mdecaro — Thu, 22 Aug 2019 15:59:51 GMT

Hi Miguel,

When I query those tables via the IDEs I typically use, there is no error on querying, and we I have tested querying the two tables (actually MVs) in a dashboard load. I did see that we typically use OLEDB connections in our dashboards, while we were setting up the Custom DSC with an ODBC.

I tested a ODBC 64-bit to load these tables, and data loaded fine into a test dashboard. I also tested a "force 32-bit" ODBC connection, and data also loaded fine. Was expecting the ODBC connection type to be the issue, but I was testing locally, but it could be a driver version issue on our production server hosting the DSC service?

Re: Configurable ODBC for DSC throwing Oracle truncate error

Brett_Bleess — Mon, 26 Aug 2019 12:33:41 GMT

Mike, I would expect you are on the correct track with the Oracle driver version running on the server if things are working on your machine etc. Oracle is pretty particular about connector versions etc., hopefully you already got things sorted, but I just wanted to confirm you were on the right track. If you did get it sorted, it would be great if you can confirm what you did and then mark that as the solution using the Accept as Solution button, that way others will know exactly what to try if they run into this as well.

Regards,
Brett