Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Asha
Contributor III
Contributor III

Qliksense does not fetch all records from Oracle View

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

 

 

10 Replies
francesco_menin
Partner - Creator III
Partner - Creator III

Hi Asha,

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