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: 
sundarakumar
Specialist II
Specialist II

Qlik Sense not loading complete data from oracle SQL

Hi Team,

I have a table in orcale DB , when i try to load the data in Qlik sense only partial data is being loaded i.e. out of 200,000 records only 30,000 records are loaded. It happens only with a particular table and it does not throw any errors also.

any idea?

Thanks in advance.

Regards,

Sundar

12 Replies
sundarakumar
Specialist II
Specialist II
Author

Hi Tom,

Thanks for the response.

Its strange, when i load different different number of columns, it breaks at different record counts.  But when i load one column it is completely loading the data!!!

For Example if the columns are Country, city, month and sales and record count is 200000

When i load Country , month and sales it loads 30000 (every time it loads the same number in this combination)

When i load Country , city and sales it loads 90000 (every time it loads the same number in this combination)


when i load only one of the fields all the records are loaded


-Sundar

sundarakumar
Specialist II
Specialist II
Author

Hi All,

I was able to fix this issue with a work around.

I just added the below code in the select statement of SQL in qlik sense load editor.


Table_name:

load

country,

city,

month,

sales;

sql select country,

city,

month,

sales,

  rownum as dummy_rownum,

    1 as dummy_number,

    '1' as dummy_num_string,

'asfdsfdsafdsfs' as dummy_string1,

    'abcdefghijklmnop' as dummy_string

from tablename;

This worked for me.

I guess this is more like making a QVD load "non-optimized" in Qlik by adding a where clause or a transformation while loading the data. (refer: optimize and non-optimze load in qvd)

But here may be it is similar thing with a sql load. with a rownum we might have forced the sql to read through all the record.

Note: may be u need to change the dummy_strings lengths if you have strings of longer length.

Happy Learning:)

-Sundar

Asha
Contributor III
Contributor III

Hi Sundar,
I'm facing the same issue, I tried adding the code in Select statement as you mentioned above..but it is still the same..There are 800K records in the View but it fetches only 31k.
Were you able to figure out what caused this issue.?

Thanks,
Asha