Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Oracle connector returns blank columns

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Oracle connector returns blank columns

Last Update:

Dec 21, 2020 6:42:26 AM

Updated By:

Sonja_Bauernfeind

Created date:

Sep 15, 2018 11:06:39 AM

When loading a table from Oracle in Qlik Sense June 2018, many columns show empty although they do have values in the database. 

Environment:
Qlik Sense June 2018 (ODBC Connector Package 5.2)

 

Fixed in:

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.

 

The workaround in previous versions:

 

Add an advanced parameter MEMLIM = 2000000 to the connector dialog. This increases the size of the buffer that the driver uses for data retrieval. 

memlim value change in edit connections.png
 

Labels (1)
Contributors
Version history
Last update:
‎2020-12-21 06:42 AM
Updated by: