Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hansyson
New Contributor III

why does loading data into qlik sense from a relational star schema fail for me?

i keep getting a memory error - it's annoying.  Tableau never had that issue for me.

8 Replies

Re: why does loading data into qlik sense from a relational star schema fail for me?

Could share the actual error you are getting ?

hansyson
New Contributor III

Re: why does loading data into qlik sense from a relational star schema fail for me?

The size of your file exceeds the file limit. File size: 81.9MB.  Size limit 25mb

Digvijay_Singh
Honored Contributor III

Re: why does loading data into qlik sense from a relational star schema fail for me?

Are you using Qlik Cloud, Basic edtion?

hansyson
New Contributor III

Re: why does loading data into qlik sense from a relational star schema fail for me?

i am using Enterprise Edition

Digvijay_Singh
Honored Contributor III

Re: why does loading data into qlik sense from a relational star schema fail for me?

Strange! Can you share more info like error screen image, data model, script etc, may be sample one. I asked about Cloud because cloud basic edition has limit of 25 MB file size.

JustinDallas
Valued Contributor II

Re: why does loading data into qlik sense from a relational star schema fail for me?

Generally, when I have this problem, it's because I'm CROSS JOINing two tables when I think I'm LEFT JOINING two tables.  This happens because sometimes I will get the key name messed up, and Qlik will see how much memory it can devour before getting put down by the OS.

Can you do a Limited Load (limit to 10 records per table if possible) and then take a look at the datamodel?

hansyson
New Contributor III

Re: why does loading data into qlik sense from a relational star schema fail for me?

the error message is exactly as i written it..  this happens when i try to attach the file and drop it in.

hansyson
New Contributor III

Re: why does loading data into qlik sense from a relational star schema fail for me?

yes- i took the big file and split it into 5 little ones.. and that seem to work.. but i don't want to have to do that every time for every load i do..

Community Browser