Qliksense does not fetch all records from Oracle View

[Asha]

Hi Everyone,

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.

Thanks,

Asha

[francesco_menin]

Hi Asha,

did you by chance encounter this issue with QlikView as well? I've had this happening with the original Oracle ODBC drivers.