Qlik Community

Ask a Question

Support Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW

Oracle connector returns blank columns

Sonja_Bauernfeind
Digital Support
Digital Support

Oracle connector returns blank columns

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)
Version history
Revision #:
2 of 2
Last update:
‎2020-12-21 06:42 AM
Updated by:
 
Contributors