We have deployed a SpagoBI 5.1.0 using an pre-made vm image from FIWARE Cloud.
We've added our PostgreSQL as a read-only data source. We've also added a few datasets and made some BIRT reports with Spago Studio. Those reports work fine, so I assume the datasets are properly defined.
Our problems start when adding a widget to a cockpit. We choose any dataset and configure the widget, and then when SpagoBI try to render it, we get an error.
Impossible to load dataset [bookings] due to the following service errors: SbiCacheItem is not mapped [from SbiCacheItem h where h.signature = ?];
It happens with any dataset, not only bookings.
Being a cache problem we added another data source (a MySQL database) with write permissions and set it as write default, but that didn't help. We also tried several values in the SPAGOBI.CACHE.DATABASE_SCHEMA configuration variable, and again got the same result.
You can find the stack trace for the error in pastebin: http://pastebin.com/KhEL8tJD
We don't know what else to try. Any ideas?
Please edit this file
/opt/spagobi/All-in-One-SpagoBI-...../webapps/SpagoBI/WEB-INF/classes/hibernate.cfg.xml
and add the following lines along with the others mapping tags
<!-- CACHE -->
<mapping resource="it/eng/spagobi/cache/metadata/mapping/SbiCacheItem.hbm.xml" />
<mapping resource="it/eng/spagobi/cache/metadata/mapping/SbiCacheJoinedItem.hbm.xml" />
then restart the server.
A write default datasource is mandatory for this kind of analysis.
Best regards