Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Problem
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
Technical info
Any help on this issue will be welcome.
I fixed it by using the Oracle OLE DB native connector.
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.
Technical Info:
Check with this:
LOAD *,
RecNo() as RecID
FROM YourTableSource;
Then you may debug the missing records from this list into sql.
May be there are special characters are there in sql.
check this:
Special Characters in the excel makes makes the data truncated when we load into the Qlikview
I fixed it by using the Oracle OLE DB native connector.