Solved: Reload taking too much time - Qlik Community

Anonymous · ‎2014-09-03

Hi ,

I hv scheduled task for reload in morning earlier it was taking hardly 5 mins to reload but now its taking 2 hours for reload what cud be the problem plz suggest.

i checked the log files but could not found exact problem

thnx in advance

ashfaq_haseeb · ‎2014-09-09

harshal hajare wrote:

actly i am fetching data from database, no qvds are generating in this dashboard,

This is not suggested at all, Always have a 3 tier Architecture to build your QlikView applications.

Step 1 DB fetch whit no or some transformations

Step 2 Transformations / ETL

Step 3 Optimized qvd loads for better performance.

harshal hajare wrote:

i hv antivirus on server,but how to eliminate folder from scanning

For this you need to talk with your security guys or sysadmins.

and make sure your server is not hosted in shared SAN drive, if yes try by moving it to server locally and check if that helped.

harshal hajare wrote:

if the problem was with antivirus then how it worked in past with same antivirus settings

when i schedule the same task on different time it workes fine like normal task

Its not blocking you always, may be you have scanning schedule or what i'm not sure you need to check with security or sysadmins.

Hope it helps.

If it answered your questions, make sure to close this thread.

Regards

ASHFAQ

View solution in original post

maleksafa · ‎2014-09-03

can you tell us more about the reload architecture that you are using? is this the final reload of the qvw? are you reading from qvds?

ashfaq_haseeb · ‎2014-09-03

Hi,

Try by deselecting Session Recovery and preload.

Check if that helped.

Regards

ASHFAQ

shane_spencer · ‎2014-09-03

Are you loading more data? more qvd's? do you have a stand alone Publisher Server or is it shared? Are you running out of Memory / Paging? have you restarted QlikView Distribution Service? (if so does it improve reload duration?) Have you checked # of Pinned Objects (as per below)? The more info you give the better the quality of the replies.

There's A Known Bug with .NET Framework 4

It was identified that there is a known bug with .NET Framework 4 that could be causing performance issues:

Reported to SE as Bug #49702 - closed as 3rd party bug:

This issue is caused by a memory leak in Microsoft FileSystemWatcher in .NET Framework 4.

The symptom is that tasks take longer and longer tor run. A restart of the Qlikview Distribution Service will temporary solve the problem. This has to do with the number of something called "Pinned objects". This number is usually in the region 0 to maybe a couple of hundred. At some customers it has been seen growing to millions. The number keeps growing until the Distribution service is restarted. As the number increased, so does the task execution time - until QDS is restarted. This can also be seen as the Distribution service consume a lot of CPU even when no tasks are running.

shane_spencer · ‎2014-09-03

It can be fixed by applying an updated detailed here:

http://support.microsoft.com/kb/2600217

Anonymous · ‎2014-09-03

yes its final reload of qvw from server im reading data from sql server database

maleksafa · ‎2014-09-03

maybe there is a problem with the connection to the sql database, is it local on the same network?

on the other hand i highly recommend you to use at least 2-tier architecture to prepare the data, the first qvw to prepare the data from sql server database and store it into qvds locally on the server and the second qvw will load the data from the qvd and have all the charts in it.

Anonymous · ‎2014-09-03

i face problem only when it runs automatically in morning ,but when i tried manually and/or setting reload trigger just for testing i didnt face any issue.its strange!!!!

ashfaq_haseeb · ‎2014-09-03

Hi,

Did you try my suggestion?

Regards

ASHFAQ

maleksafa · ‎2014-09-03

it must be a connection issue.

Reload taking too much time

Related Topics