Out of Object Memeory Errorr while loading data from Excel 2007

[spsrk_84]

Dear All,

I have a system with Windows server 2003 ,Core2 Duo processor with 4GB RAM.But i am getting "Out of object Memory " Error when i am trying to load data from a Excel 2007 file which is having around 0.45 million (4.5 lakhs records)rows of data.

Is it is the limitation in Qlikview 9.0 ?

Please provide me spme solution to resolv this issue.

Thanks In Advance

Regards,

Ajay

[#2]

It might have happened due to synthetic keys. Kindly check!

[#3]

You can get this error for a number of different reasons. Your ram is more then enough to handle that many rows. Synthetic keys (Do a crtl + t) will kill the performance of your app. In fact, if you have just one $syn key with that many rows you will get an object out of memory. You can fix those keys by either removing a field name, or joining/concatenating the tables together.