Data Refresh of Cockpit Dashboards does not work

Question

HI,

I've a query dataset from a table that increase itself of one record every 15 minutes. With this dataset I create a cookpit with Knowage Server CE 6.0 and at the first run all work fine but data seems to be fixed in a data/time that does not change as it should.

If I try to run a data preview from DataSet all work fine.

I try to delete the cache on my PC: nothing change.

I try to run the Clean Cache on the cookpit: nothing change.

I need that the data in the table and chart of the cookpit will be update to the last record exposed (correctly) by dataset.

What I need to do?

Tks

Marco

Answer 1

First of all, I would suggest to update Knowage to the latest version released (6.1.1). Starting from version 6.1.0 Knowage introduces the option to deselect "Use cache".

Then, if you are using a query dataset from a relational database (Oracle, MySQL, Postgresql etc), you can rely on query on those datasource without using the cache. In this way, you will always get fresh data directly from your datasource instead of retrieving them from the cache.

Please note that not all the datasources can be used without cache. We are in the process of better highlight this aspect in order to avoid any other confusion.

Comments

Thank you.

I suppose that the screenshot is related to the new version because I'm not able to see in the knowage 6.0 version.

Is it so?

---

Yes, indeed. This is available from vesion 6.1.0

---

I'd like to know if MSSQL can be used without cache, because all the times I start a cockpit with 'use cache' deselected it says "there was an error while loading widget xxx"