Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
enricocamerin
Creator
Creator

Oracle Driver unstable. Not all the rows are loaded

Hello we are using the release  June 2018

Regarding the connection we are using  the oracle driver.

When I load the script each time I have a different number.

I isolated a fragment of the sql script with only the select  removing the load .

So the problem is somehow in the connector.

if I run the query in toad I have for example 400000 row

The same sql loaded  in qliksense gives only 35000 rows, but sometime( 10 second later) it gives the correct number 400000.

then if I add a field in the select the number change again.

The behaviour is very weird and unstable.

in the previous release we used the Qlik odbc connector package with no problem

thanks in advance for your suggestion

Enrico

12 Replies
ZDonn
Contributor II
Contributor II

No, no additional steps needed after replace the oracle folder under QvOdbcConnectorPackage. Did you unzip the file?

Filippo_Nicolussi_P

If someone will try to add the advanced setting :

MEMLIM   to   2000000

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
blaise
Partner - Specialist
Partner - Specialist

a big thank you @Filippo_Nicolussi_P for the suggestion to add the MEMLIM parameter - solved my issue with Sep2018 Path2