When loading a table from Oracle using the Oracle connection object in Qlik Sense June 2018 (ODBC Connector Package 5.2) or higher, many rows show empty values in most columns. As the result, some data are missing after the load.
The below error message can be found form script log.Error: Connector is not responding (System error: ***)
Sometimes there might not be an error, but the number of rows expected are not present in the loaded table or qvd. Environment
: Qlik Sense June 2018
Qlik Sense February 2019 Patch 1 (Release notes
Qlik Sense April 2019 (Release notes
and later releases.
See the relevant Release Notes for ID QVXODBC-1615.
Workarounds for previous versions:
See the following site for additional troubleshooting for this type of issue. Oracle: Empty rows in Oracle tablesWorkaround 1
Use the generic ODBC connection instead of the Oracle ODBC connectionWorkaround 2
Add an advanced parameter to the Oracle ODBC connection:
MEMLIM = 2000000
Testing has shown that this resolves the issue in most situations.Workaround 3
Replace the Qlik-provided ODBC Connector Package in your environment with ODBC Connector Package 4.0 by following the below steps.
- Find your current ODBC Connector Package from C:\Program Files\Common Files\Qlik\Custom Data and rename it.
- Install ODBC Connector Package 4.0 (This can be obtained from the Support Portal, in the Software Downloads area. Under Qlik Connectors > Qlik ODBC Connector)
- After installation, move the ODBC Connector Package folder from C:\Program Files\Common Files\QlikTech\Custom Data to C:\Program Files\Common Files\Qlik\Custom Data
Please reference product documentation for more information about Installing ODBC Connector Package
.on the Qlik Connectors page.