Error creating Cockpit

Question

Hello,

I have a probleme when I want to create a simple chart inside a Cockpit. I receive an error "generic error".

If I look at the log file, I received this error:

14 Jul 2017 17:42:44,984 ERROR it.eng.spagobi.tools.dataset.persist.PersistedTableManager.dropTableIfExists:652 - Impossible to drop the temporary table with name SbiTest46
java.sql.SQLException: No database selected

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

...

[http-bio-8080-exec-5] 14 Jul 2017 17:42:44,987 ERROR it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset:244 - Error persisting the dataset into table

it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Impossible to drop the persisted table with name SbiTest46

at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.dropTableIfExists(PersistedTableManager.java:653)

....

I want to precise that I am using All-in-One-Knowage-6.0.0_RC_CE.

This is weird because I already succed doing a Cockpit bu t I don't know what happened. Now even my old Cockpit does not work anymore.

Thank you in advance

Answer 1

First of all I strongly suggest to upgrade to the last release.

Starting from that, we can investigate your issue.

Let me know if you have the same error after the upgrade.