topic Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection in Management & Governance

Qlik Sense June 2018 weird Lines fetched with Oracle connection

yannick_caillat — Tue, 17 Jul 2018 15:19:07 GMT

After upgrading to Qlik Sense version June 2018, the number of lines fetched by apps decreased compare to what we expect or fro some retrieved rows we have empty value for non-numeric value.

Case 1
select * from RTC_IMA.RTC_OLV_QS_OS_DVT where "Product Name" not in ('Credit Line');
Lines fetched: 45.240 --> KO we should get 401785

Case2
select * from RTC_IMA.RTC_OLV_QS_OS_DVT where "Product Name" in ('Credit Line');
Lines fetched: 3.712 --> OK with the number of rows in the source

Case 3
select * from RTC_IMA.RTC_OLV_QS_OS_DVT;
Lines fetched: 44.922 --> KO we should get 405497

In the past, we already configured Advanced properties for this ODBC connection :

EncryptionLevel = 1

DataIntegrityLevel =1

QueryTimeout = -1

Does anyone have trouble with the ODBC connector for Oracle ?

Do I have to setup another Advanced properties ?

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

ZDonn — Tue, 17 Jul 2018 22:15:10 GMT

I just found myself in the same issue. By adding the LIB command before each query seems to solve the problem for now. But then I found values are missing from some fields, still debugging on that. Hopefully this info can help.

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

yannick_caillat — Wed, 18 Jul 2018 06:06:48 GMT

I confirm that adding the LIB command before each quey solve the problem with number of lines fetched. But as you said I still get missing values for some fields

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

yannick_caillat — Thu, 19 Jul 2018 09:37:19 GMT

I followed Qlik support instructions : as my orginal connection used th built in Oracel ODBC I have switched to the official Oracle driver. For now, the issues are fixed

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

enricocamerin — Fri, 20 Jul 2018 07:48:54 GMT

for me is not working this workaround I still have much less row even adding lib before each SQL.

Enrico

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

ZDonn — Fri, 20 Jul 2018 14:00:57 GMT

I just switched to the OLE DB Provider yesterday as well. Still running data validations but everything looks OK so far.

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

ZDonn — Fri, 20 Jul 2018 20:02:00 GMT

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

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

Filippo_Nicolussi_P — Thu, 25 Oct 2018 12:29:45 GMT

Someone has tried to set in Advanced section

MEMLIM to 2000000

Re: Qlik Sense June 2018 weird Lines fetched with Oracle connection

Anonymous — Thu, 25 Oct 2018 16:25:44 GMT

Hello,

from tips:

https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Troubleshooting.htm

it seems to be MEMLIN the parameter to use.
Try it anyway with both but it does not work.