Hello, I have a long-running report for both email subscription and file share delivery subscription, with same parameter values.
I set up a cache options and wanted to just run for once for both subscriptions since it's a long-running report.
It works as expected - only if the second subscription starts after the first subscription finishes, the second subscription retrieves cached report rendered from the first subscription.
However, if both the subscriptions start at the same time, then they both do the actual report processing and retrieve data from live, which I can tell from the source column of the view reportserver.dbo.executionlog3 being Live instead of Cache. I tested
that both the two concurrent report requests from IE retrieve data from Live instead of Cache too, if they start with no cache.
I cannot predict how long the report needs to be rendered therefore I can only schedule them at the same time.
Could you please help how I make sure only one actual report data retrieve occur even for concurrent refresh report rendering? Any solution or workaround will be highly appreciated!
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.