topic Re: Oracle Driver unstable. Not all the rows are loaded in Connectivity & Data Prep

Oracle Driver unstable. Not all the rows are loaded

enricocamerin — Wed, 18 Jul 2018 14:16:55 GMT

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

Re: Oracle Driver unstable. Not all the rows are loaded

ZDonn — Thu, 19 Jul 2018 14:44:35 GMT

We had the same issue here, too.

Qlik Sense June 2018 weird Lines fetched with Oracle connection

Re: Oracle Driver unstable. Not all the rows are loaded

PabloTrevisan — Thu, 19 Jul 2018 15:09:18 GMT

If the problem is instability, you can parallelize the select since you are making the connection between qliksense and oracle without eg sap connector ...

the command:

SET StripComments =0;
EKKOtab:
SQL SELECT /*+ PARALLEL(VBRK 😎 */ FIELD1,FIELD2
FROM VBRK;
SET StripComments=1;

EKKOtab:
SQL SELECT --+ PARALLEL(VBRK 😎  FIELD1,FIELD2
FROM VBRK;

Godd lucky !

Re: Oracle Driver unstable. Not all the rows are loaded

enricocamerin — Thu, 19 Jul 2018 15:38:11 GMT

Thanks Pablo I tried but it didn't solve the problem I still have weird result.

Re: Oracle Driver unstable. Not all the rows are loaded

bi_licenze — Thu, 19 Jul 2018 22:35:16 GMT

I had the same issue. If you look in the event viewer you'll see a crash of Qvodbcpackageconnector.

As a workaround you have to rename the folder

C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage

in _OLD and copy the folder of Qlik Sense April2018.

Oracle connector in June 2018 is not working fine.

Bye,

Simone.

Re: Oracle Driver unstable. Not all the rows are loaded

ZDonn — Fri, 20 Jul 2018 19:59:09 GMT

This actually works! Easier than going through the whole Oracle ODAC thing. I used the oracle package (~\AppData\Local\Programs\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\oracle) from Qlik Sense Desktop April 2018 release, as attached, to replace the one in the new Qlik Sense June 2018 under the similar folder C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage.

Re: Oracle Driver unstable. Not all the rows are loaded

enricocamerin — Mon, 23 Jul 2018 07:18:09 GMT

Thanks Simone I have sent the procedure to the IT department

I'll let you know

Re: Oracle Driver unstable. Not all the rows are loaded

enricocamerin — Mon, 23 Jul 2018 07:18:56 GMT

Thanks for the Driver I'll let you know as soon as we carry out the process

Re: Oracle Driver unstable. Not all the rows are loaded

enricocamerin — Mon, 23 Jul 2018 09:03:47 GMT

thanks it Works !!

Re: Oracle Driver unstable. Not all the rows are loaded

pietvanduijn198 — Thu, 09 Aug 2018 08:05:27 GMT

Do you need any other actions after the replacements, because i had NO oracle driver now.

Unkown connection type "QvOdbcConnectorPackage" is mentionned within data connection.

Re: Oracle Driver unstable. Not all the rows are loaded

ZDonn — Thu, 09 Aug 2018 19:20:07 GMT

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

Re: Oracle Driver unstable. Not all the rows are loaded

Filippo_Nicolussi_P — Thu, 25 Oct 2018 12:32:19 GMT

If someone will try to add the advanced setting :

MEMLIM to 2000000

Re: Oracle Driver unstable. Not all the rows are loaded

blaise — Thu, 04 Apr 2019 14:32:12 GMT

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