Error on dataset previewing

Question

I am testing the knowage to decide whether to use it or not. When I create a dataset in the biadmin user and having seen it as a biuser user, an error occurs as follows:

Comments

Hi vitor.ghiotti,

can you please send me the list of the steps you have done to obtain this error so I can try to reproduce it?

Moreover, can you send me also the log stacktrace you can find in knowage.log files located in the "<installation folder>/Knowage-Server-CE/logs"?

Thank you.

Greetings
Alberto

Answer 1

good night, follow the steps below:
1- I installed the knowage
2- in the admin user I uploaded a csv file
3- in the BIUSER user I located the dataset and clicked on the visualization icon
4- the error message appears

the log is in https://drive.google.com/file/d/1TlOvtX8ncRUd-Uiv_xqo8eGdF2yX_K12/view?usp=sharing

Answer 2

Dear

I think that the issue is related to how knowage is configured.

I can see in the logs:

Caused by: java.lang.RuntimeException: it.eng.spagobi.utilities.database.DataBaseException: The database Apache Hive v2 cannot be used as cache

To use file data set you have to configure properly the cache ( https://knowage-suite.readthedocs.io/en/7.2/installation-guide/manual-installation.html#configuration-of-the-metadata-db-dialect )
1) create an empty schema
2) create a JNDI connection pool in server.xml
3) create a new Data Source inside Knowage, you have to mark as "Use as cache" this connection.

Remember to user Oracle, MySQL , Maria DB, PostGreSQL as cache DBMS.

Best Regards
Angelo