ReportServer Forum

dennisliu

Member

Registered: 2015-01-16

Dashboard Report unable to refresh

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

datenwerke

Registered: 2012-02-14

Re: Dashboard Report unable to refresh

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

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

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

datenwerke

Registered: 2012-02-14

Re: Dashboard Report unable to refresh

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

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

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

datenwerke

Registered: 2012-02-14

Re: Dashboard Report unable to refresh

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

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

Hi, Arno,

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

2. Create a Pivot Report

3. Create a Dashboard Dadget using Pivot report and display format is stacked bar chart.

4. Try to change data

5. After data updated, the dashboard refresh button is not working, I need to restart Tomcat server to make ReportServer reload data.

6. Re-login after tomcat restart

7. Firebug network log

Sincerely,
Dennis

Thorsten J. Krause

Guest

Re: Dashboard Report unable to refresh

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

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

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

Thorsten J. Krause

Guest

Re: Dashboard Report unable to refresh

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/ … che.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

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

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!

Sincerely,
Dennis

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Dashboard Report unable to refresh

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

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

Hi, Arno,

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

1. Script from Thorsten provided

2. Create a Pivot report and run from TeamSpace

3. Preview report out, check data then close report

4. Update database data and commit

5. Re-execute report from report list

6. Report cached old data, not refresh

7. Report data only refresh when logout and re-login, reopen report to execute

Best regards,
Dennis

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Dashboard Report unable to refresh

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

Thorsten J. Krause

Guest

Re: Dashboard Report unable to refresh

Hi Dennis,

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

Cheers,
Thorsten

dennisliu

Member

Registered: 2015-01-16

Re: Dashboard Report unable to refresh

Hi, Thorsten,

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

Sincerely,
Dennis

sdavies68

Member

Registered: 2015-02-11

Re: Dashboard Report unable to refresh

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

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

datenwerke

Registered: 2012-02-14

Re: Dashboard Report unable to refresh

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

Member

Registered: 2016-10-19

Re: Dashboard Report unable to refresh

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?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Report unable to refresh

Hi quintg,

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

Cheers,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Report unable to refresh

Hi,

The Mondrian data cache can be cleared with help of a button in the new ReportServer 3.0.8. Check the release notes: https://reportserver.net/releasenotes/RS3.0.8.html

Regards,
Eduardo

DOCUMENTAL

Member

Registered: 2020-01-20

Re: Dashboard Report unable to refresh

RS3.1.0-6015
the cache clear button is not working for us, in a  mondrian report of a cube with parameters. only refreshes when the xml schema is changed

is there another way to refresh it? a script that can be scheduled daily?

also in saiku when we click on refresh button there is an exception
java.lang.RuntimeException: org.hibernate.LazyInitializationException

regards

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Report unable to refresh

Hi DOCUMENTAL,

what exactly is not working for you with the cache clear button? Do you get an error? If yes, please post the complete error stack.

Regarding the LazyInitalizationException: please try with the latest RS3.1.0-6018. is this working here? If not, again, please post the complete error stack.

Regards,
Eduardo

DOCUMENTAL

Member

Registered: 2020-01-20

Re: Dashboard Report unable to refresh

Thanks eduardo

when we click clear the datasource cache it doesn't throw an error, it says the cache has been deleted, but after that, if we execute the cube report again it throws the same cached data. i have checked that the info in the database is different. In the datasource schema we use parameters.

with this script it seems it is cleared:

Class rspc = Class.forName("mondrian.rolap.RolapSchemaPool");
            def pool = rspc.instance();
            pool.clear();

could someone provide an example script for only refreshing a specific datasource?

kind regards

Last edited by DOCUMENTAL (2020-01-21 14:05:49)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Report unable to refresh

Hi DOCUMENTAL,

can you please provide the complete SQL statement inside your cube ?

Regards,
Eduardo