0 votes
1 view

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:

Environment knowage 7.2 CE; windows 10, chrome
asked Sep 7, 2020 in Data Set by vitor.ghiotti (220 points) | 1 view
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

2 Answers

0 votes
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
answered Sep 14, 2020 by vitor.ghiotti (220 points)
0 votes
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
answered Sep 23, 2020 by abernabei (20,700 points)
1,553 questions
1,017 answers
2,037 comments
2,567 users