I'm loading a moderately large table (5M rows, 100 fields) into Qlik Sense from an Oracle database. The reload task is successful, but sometimes, not all rows are loaded. However, if the reload is started from the "Reload data" button in the app's script, all rows are always loaded.
Comments / Hints
The loading is done via LOAD *; SELECT * FROM MY_TABLE.
The log shows no error.
Nobody is using the Oracle table during reload.
The number of missing rows is random.
Spliting the loading in blocks of, say, 100,000 rows and concatenating helps, but sometimes there are still missing records.
I have the same problem. When I try to load with a SQL than retrieve 3,646,054 rows, some records are missing. Running the load once and again, total records loaded are allways 3,298,900 (347,154 lost!). I solved this issue splitting the loading in blocks and concatenating too. But there are some problem here with Qlik Sense, because the log shows no error.