topic Re: QlikView Desktop stuck when loading database from SQL server in QlikView

QlikView Desktop stuck when loading database from SQL server

Mon, 26 Jan 2026 18:19:17 GMT

We are testing QlikView Desktop 11. When trying to load data from an about 2GB SQL database, reloading process stuck like forever. There was no alert. Is there anyone that meets this error? And how to fix it.

Re: QlikView Desktop stuck when loading database from SQL server

Gysbert_Wassenaar — Wed, 20 May 2015 05:38:41 GMT

First use the debugger to do a limited load to see if any synthetic keys are created during the load. Synthetic keys are created when tables have more than one field in common. The creation of these synthetic keys can take a lot of ram and processing power. The same is true for joins. Once you've made certain that your data model is not a problem then reload with more data and monitor ram and cpu usage of your machine. 2 GB source data is quite a bit for a desktop system. You may simply have to get a machine with more ram.

Re: QlikView Desktop stuck when loading database from SQL server

Wed, 20 May 2015 05:55:32 GMT

Thanks gwassenaar‌,

Actually I save alert about relationship when loading just 2 table. But I think that should not be problem cause company application use this database normally.

About the resource, I provided this desktop VM 5GB, and QlikView just used less than 1GB RAM.

Re: QlikView Desktop stuck when loading database from SQL server

Gysbert_Wassenaar — Wed, 20 May 2015 07:30:01 GMT

Actually I save alert about relationship when loading just 2 table. But I think that should not be problem cause company application use this database normally.

But your application doesn't have to create an in-memory database that Qlikview needs to function properly.