Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
AChris
Contributor
Contributor

Data Load Error: Unknown

Hi, I just tried to load half a billion rows of data from 13 different tables using the data load script editor in Qlik Sense Enterprise (Nov 2018 version). It took 2 hours to load the data, 30 minutes for qlik to create the 6 synthetic keys I had planned for the data load. Then it took 10 minutes extra before it crashed and I got the following messages pop up under my "Data load progress":

"The following error occured:
-1 ="

and also this message right underneath it:

"The error occurred here:
?
Unknown Error"

Then it finally said underneath all that:
"Data has not been loaded. Please correct the error and try loading again."

I don't know which one of all my data associations failed and why it failed. How can I troubleshoot this issue?

Labels (3)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Synthetic keys may work in many cases but IMO they are a serious lack in the datamodel especially if there are multiple ones and by large datasets - and their creation needs a lot of resources and you might hit the available RAM and your observed error-message could be a result of it.

I suggest that you load a reduced dataset maybe just a few thousand records and adjust the datamodel.

- Marcus