When I try to visualize a cockpit based on a complex query, after a while, before result data are shown, I get the error
Widget new Widget Unable to load data from dataset ...
Please check dataset & widget config
and the first error I detect in the log file is
[http-bio-8080-exec-1] 11 Jul 2019 14:01:46,771 ERROR it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore:452 - An unexpected error occured while executing method
it.eng.spagobi.tools.dataset.cache.CacheException: An unexpected error occure while getting dataset from cache
I have created a datasource to be used as cache as shown in the following image:

is this correct?
I've read in the doc that I should define a source as 'WRITE default': how can I do this?
Thx,