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.
Thanks in advance.
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.
sql select country,
rownum as dummy_rownum,
1 as dummy_number,
'1' as dummy_num_string,
'asfdsfdsafdsfs' as dummy_string1,
'abcdefghijklmnop' as dummy_string
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.
Check the driver and with the Oracle DBAs. Most of the cases this issue was reported in the Qlik Community was due to limitations on the amount of rows the account can extract, in either the definition of the account or the settings of the client.
Thanks for the response.
I doubt if this issues would be anything about extract limits. Because this issue happens with only one table. I am able to load millions of records from other tables in the same table.
I don't, security can be set up by table, actually makes sense, dimensional tables have no limits, but fact tables are limited so you have to perform incremental updates.