Using Configurable ODBC DSP together with Oracle 11g may not work properly with the following symptoms:
- No users or groups can be fetched in the QlikView Management Console
- The following error can be found in the Directory Service Connector log (C:\ProgramData\QlikTech\DirectoryServiceConnector\Log):
Error (Database.DatabaseProvider) Exception 'System.OverflowException: Arithmetic operation resulted in an overflow
In Qlik Sense, when setting up User Directory Connectors, following error shows up:
This is a known bug in the Oracle ODBC driver, with bugid #9793452 (Oracle bug id).
Upgrading to latest ODBC driver (22.214.171.124) will solve the issue
Upgrade to the latest Oracle ODBC drivers (126.96.36.199 or higher):
- Follow the instructions in the release notes to install the ODBC driver.
Note: Visual C++ 2005 SP1 Redistributable Package must be installed or you may experience the following error when setting up the System DSN:
The setup routines for the Oracle in instantclient_11_2 ODBC driver could not be loaded due to system error code 14001.