Dashboard Report unable to refresh

ReportServer (EN)
21

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

22

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

23

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

24

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

25

Hi DOCUMENTAL,

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

Regards,
Eduardo