Dashboard Report unable to refresh

dennisliu · June 17, 2015, 10:14am

Hi,

I created a stacked bar chart in dashboard, I wish it can display the current database data when open dashboard each time.
However when database data changed, the bar chart seems fixed in previous data and refresh is not work.

Is there any configuration I need to setup? Please help, thank you~

The version of ReportServer I used is 2.2.2.5639 and my database is Oracle 10g.

Arno_Mittelbach · June 17, 2015, 5:41pm

Hi Dennis,

if you reference a report in a dashboard the report is currently loaded only once when the dashboard is first displayed. You can manually reload the report by clicking on the reload button of the dadget (top right). If you want an automatic refresh I am afraid there is no simple solution at the moment. What you could go for is to write a custom HTML page which embeds the report in an iframe and refreshes regularly using javascript.

Cheers
-Arno

dennisliu · June 18, 2015, 4:05am

Hi, Arno,

Thanks for quick reply!

I did try to reload the bar chart by clicking on the reload button of the dadget, however the bar chart still fixed in the previous data unless I restart Tomcat server the dashboard will reload but just once. After that if my database data changes the reload function still not working.

I don’t want an automatic refresh but I wish the dashboard dadget refresh function will working.

Sincerely,
Dennis

Arno_Mittelbach · June 20, 2015, 7:43am

Hi Dennis,

this is indeed odd. What kind of report are we talking about here? Could you maybe try the following. Could you use a tool such as FireBug (http://getfirebug.com/) and have a look at the network traffic once you hit the refresh button? What you should see is that a request is made to the server. Is that the case?

Cheers
-Arno

dennisliu · June 22, 2015, 2:49am

Hi, Arno,

I have downloaded and installed the FireBug plugin for Firefox, and I tested the refresh button, but how do I know the network traffic between ReportServer and database is normal?

BTW, I installed another ReportServer environment and retry the same scenario, when my external database data changed, the dashboard refresh button still not working.

P.S. may I upload image to the forum? Maybe I can upload some images for your references.

Sincerely,
Dennis

Arno_Mittelbach · June 22, 2015, 6:33am

Hi Dennis,

FireBug can simply tell you whether a request occurs, once you hit the refresh button. Once we can confirm that this happens we can start trying to understand what goes wrong. For example,
FireBug allows us to have a look at the data being sent to the server and data coming back from the server.

What kind of report are you using? A dynamic list, a jasper report, BIRT?

You can upload images to http://snag.gy/ and link to them from here.

Regards
Arno

dennisliu · June 22, 2015, 9:03am

Hi, Arno,

I am using a dynamic list with Pivot mode, here are the images for your reference.
1.Create a Dynamic list

Create a Pivot Report
Create a Dashboard Dadget using Pivot report and display format is stacked bar chart.
Try to change data
After data updated, the dashboard refresh button is not working, I need to restart Tomcat server to make ReportServer reload data.
Re-login after tomcat restart
Firebug network log

Sincerely,
Dennis

Guest · June 22, 2015, 9:05pm

Hi Dennis,

thank you for the detailed instructions. I can reproduce the issue and will try to figure out whats going on.
I’ll let you know what I find.

Cheers,
Thorsten

dennisliu · June 23, 2015, 1:51am

Hi, Thorsten,

I also found this problem could also happened in execute the Pivot mode report, the report data wouldn’t update when database data changed.
FYI~

Sincerely,
Dennis

Guest · June 23, 2015, 8:38pm

Hi Dennis,

looks like some cache is not being properly flushed between report executions.
As a workaround use this script
http://www2.datenwerke.net/files/forum/t376/flushMondrianCache.groovy
and place it in /fileserver/bin/onstartup.d/
after a restart the cache gets cleared before each report execution. A permanent fix will be included in the next release version.

Thank you again for reporting this.

Kind regards,
Thorsten

dennisliu · June 24, 2015, 1:53am

Hi, Thorsten,

Thank you for your great help, the dashboard chart refresh button is working.

However the Pivot mode report has similar problem, I need to re-login ReportServer to make the Pivot report data refresh.
And also need your help to check this problem. Thank you again!

Pivot mode report

Sincerely,
Dennis

Arno_Mittelbach · June 24, 2015, 3:57pm

Hi Dennis,

while having the report open the data is indeed cached. However, once you completely close the report and reopen it (and if you have hooked in the script Thorsten provided) the cache should be cleared. Could you verify this?

Regards,
Arno

dennisliu · June 25, 2015, 3:53am

Hi, Arno,

I have implemented the scripts that Thorsten provided, below is the scenario I tested for your reference.

Script from Thorsten provided
Create a Pivot report and run from TeamSpace
Preview report out, check data then close report
Update database data and commit
Re-execute report from report list
Report cached old data, not refresh
Report data only refresh when logout and re-login, reopen report to execute

Best regards,
Dennis

Arno_Mittelbach · June 25, 2015, 6:12am

Hi Dennis,

thanks for the detailed description. It seems that the cache clearing script needs to be slightly changed to catch this. We’ll look into this.

Regards
-Arno

Guest · June 28, 2015, 10:29am

Hi Dennis,

I updated the script (http://www2.datenwerke.net/files/forum/t376/flushMondrianCache.groovy)
Closing and repoening the report now causes the cache to get flushed.

Cheers,
Thorsten

dennisliu · June 29, 2015, 1:52am

Hi, Thorsten,

Thanks for your help, this problem has been solved. Thanks again~

Sincerely,
Dennis

sdavies68 · December 9, 2015, 2:58am

Hi Arno, how can I call a report in an iframe?

I am happy to pay anyone to do this for me. I need it urgently. I have a number of dynamic reports which I need to refresh every minute.

Regards

Stephen

Arno_Mittelbach · December 9, 2015, 9:49pm

Hi Stephen,

tell you what, I’ll give you the idea, and if you want you can write a short review for ReportServer on G2Crowd or on Bitnami.

Here is one way of doing it. Use an HTML Dadget and a code like the following:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
      <head>
      <script type="text/javascript">
        /* resize iframe */
        window.onresize = function(event) {
       	       var  html = document.documentElement;
   	       var height = Math.max( html.scrollHeight, html.offsetHeight );
	       document.getElementById("theframe").height = height + "px";
        };
        
	setInterval(function() {
            document.getElementById("theframe").src = document.getElementById("theframe").src
	},10000);
	</script>
	</head>
	<body style="margin: 0px; padding: 0px;">
          <iframe width="100%" height="100%" scrolling="no" frameborder="0" id="theframe" src="http://SERVER/reportserver/reportexport?id=39&format=html&download=false">
          </iframe>
	</body>
</html>

This will render the dynamic list as HTML and reload it every 10 seconds.

Hope this helps

Arno

quintg · March 1, 2017, 8:33am

Hi, I am using v3.0.2 and notice the cache is not getting cleared at every report execution. And imho it shouldn’t, I’d rather like it cleared only daily since we have a scenario of a daily ETL job feeding our datawarehouse. So I could schedule a similar script to clear the cache daily. Is this a sensible approach?

IF_Eduardo · March 2, 2017, 10:17am

Hi quintg,

what exactly do you have in mind? what reports are “not getting cleared” ? and when and where does this happen ?

Cheers,
Eduardo