Hi, I have a query regarding report refreshes. There are 5-6 reports that I have published to online service and shared with users. These reports have same sql servers connected. One of my report takes about 30 minutes to refresh and the second takes about 45-55 minutes. When all of these refresh at the same time they all take a very long time and mostly 2-3 fail to finish, giving reason "The gateway operation has been cancelled explicitly by the user or from a timeout". So, I have sequenced their scheduled refreshes at different intervals of the day (max 3 refreshes in an interval and atleast 30 minutes apart) to prevent over burdening of resources. Now, if one or two of them takes more than 30 minutes they overlap in second interval and sometimes 1 or the other fail.
This has led me to keep checking them atleast 7-8 times a day to see if all of them finished refreshes or not. It is now becoming an effort to keep track and reporting to users that their report failed for this reason.
Currently the PC where my gateway is installed has core i7 6700 CPU, 3.4Gz, window 10Pro 64bit, on dynamic RAM, ranging from 512MB talo 12288MB.
Can dynamic RAM be a problem ?