Created question in FIWARE Q/A platform on 19-11-2015 at 12:11
Please, ANSWER this question AT https://stackoverflow.com/questions/33802566/error-adding-widgets-to-a-cockpit-in-spagobi-5-1-0

Question:
Error adding widgets to a cockpit in SpagoBI 5.1.0

Description:
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

Screenshot of the error

We don't know what else to try. Any ideas?