Out of virtual logical memory

[#1]

Hi everyone,

I have such a huge problem!! that makes me tear my hair out...

I-ve tried to load the sript in others machines with much more memory, but i got the same message.

How can i do? why is this happening exactly...?

thxs in advance

[vgutkovsky]

First, try to get rid of your synthetic keys. That might do the trick since those often cause unexpected behavior and you seem to have a lot of them being generated.

Regards,

[johnw]

Although synthetic keys are not always a bad thing, I suspect your eight synthetic keys are there by accident instead of on purpose. That would suggest that you've made a complete mess of your data structure, and QlikView finds it impossible to load it as a result. What you need to do is fix your data structure.

Easier said than done, of course. I recommend doing the load bit by bit, adding one table at a time. After each load, make sure you still have the data structure you expect. Make sure you still have the right number of rows on each table that you expect. Make sure the tables connect like you'd expect. If a synthetic key appears, make sure it's one you intended to have. Figure out where things start going wrong, and fix it. Then keep going until something goes wrong again, or until you've made it through the whole load successfully.

[#4]

Oook! I think i-ll star for the beggining then...!

Thxs.