I am trying to load data from a table in Oracle into Qlik Sense Desktop. This table has around 5 million records.
Qlik Sense Desktop machine has 16GB RAM. While doing the data load in Qlik Sense the load is stopping midway and not progressing. Any idea what is the reason ?
Is it giving any error?
Nope, no error. Just unresponsive.
if you have date in your data set then you can store monthly qvd's one by one.
5 million records is just one month data. Meanwhile, we are trying to split it into smaller sections and create QVD.
Did anybody face any issue like this ?
Try to load a small data set, analysing memory and cpu each process, and increasing this limit until reach the problem.
Sometime the best way is reduce data set or update the database driver on Qlik Sense.
Retrieving data ...