Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trappersw
Partner - Creator
Partner - Creator

Reload goes wrong and the next day the problem seems solved without changing a thing.

I have a issue with the scheduled reload on the server.

The strange thing is, sometimes a reload goes wrong, and the next day, without changing anything the problem seems solved and the reload is completed without errors.

Any ideas what can cause this?

Thanks in advance, Wouter

1 Solution

Accepted Solutions
richard
Partner - Creator
Partner - Creator

You might be facing performance peeks on your server that stand in the way of reloading successful every time.

Try the following:

1. Change the schedules to intersections of time where no server backups are made or any other background activity is busy.

2. upgrade RAM.

3. upgrade CPU capacity.

Ofcourse the last two are related to the size of QVW's calculation done when reloading.

View solution in original post

8 Replies
richard
Partner - Creator
Partner - Creator

You might be facing performance peeks on your server that stand in the way of reloading successful every time.

Try the following:

1. Change the schedules to intersections of time where no server backups are made or any other background activity is busy.

2. upgrade RAM.

3. upgrade CPU capacity.

Ofcourse the last two are related to the size of QVW's calculation done when reloading.

trappersw
Partner - Creator
Partner - Creator
Author

Hello Richard,

Thanks for the reply. I will have to check with IT when they backup.

The server is on a virtual server, I assume this is not ideal in this story.

Not applicable

I share Richards guess that it might be performance related and would recommend that  you looked at the task logs to see if you can get any information why the task failed.

Good luck

trappersw
Partner - Creator
Partner - Creator
Author

Hello Hampus,

Thanks for the reply. Next time I will save the log, but this time it is already replaced by the next log.

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Wouter.

I recently had the same issue.

I went through the process of double checking for any contention in the schedule (e.g. weekly jobs running at the same time as monthly jobs etc) and whether there were spikes in the amount of data being processed.

The problem was with the 3rd party virtual server. Unknown to us, the virtual server resources were shared by other clients which was causing the problem.

Regards,

Neil

trappersw
Partner - Creator
Partner - Creator
Author

Hi Neil,

Thanks for your respons. The virtual server is managed internally, but I can imagine when the sharepointserver is backed up, this has repercussions for the other virtual machines as well.

Best regards,

Wouter

trappersw
Partner - Creator
Partner - Creator
Author

Apparently no backups are being taken at the time of reload. Something else will have to be going on.

Other thoughts?

Not applicable

We had issues initially with Virus Scanning kicking off. Finally had our IT add exceptions to skip QlikView file extensions.