This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to load a View from Oracle which has 800,000+ records. But Qlik fetches only 31,000 records. It works fine with other tables and Views.
My SQL is as simple as below
Select * from TableName ;
So far I have tried below
1. Deleting my connection and recreating it but it did not help.
2. Tried the solution from here.
We have raised a ticket with Qlik.
They were able to solve it by adding Parameters under 'Advanced' in the connection details as below and advised to use OLE DB connection over ODBC.
View solution in original post
Are you hitting the correct data source? May be Prod vs dev issue?
Have you tried with the alternate connection type? If you are using ODBC, try OLEDB... or vice versa
I've had issues with Oracle not returning all records before, although it was random, it appeared to be an Oracle issue with cached queries.trysql alter session set "_nlj_batching_misses_enabled" = 0;after the odbc connect statementIt forces the query to run on the data not on memory, possibly slower and more demanding on the oracle db
edit: you may need additional rights from the Oracle admin