Features of admin user interface missing

Question

Hello,

I have installed Knowage 7.1 in docker as per https://hub.docker.com/r/knowagelabs/knowage-server-docker

I logged in via username/password as biadmin and I am not able to view detail menu, workspace and admin interface which can help me add dataset, documents etc.

Below is a screenshot of interface I am getting when login with biadmin credential on localhost.  With bidev and biuser, I am getting a completely blank white screen.

Please help me find steps I am missing to get knowage up and running. 

Comments

Hi sauravshandilya,

Do you see any error in log files?

Best regards,

Andrijana

---

Hello Andrijana,

Thank you for showing right direction.

There are error in log file related to Quartz table.  

---

MySQLSyntaxErrorException: Table 'knowagedb.QRTZ_TRIGGERS' doesn't exist

---

I am attaching the log files. Please help me in resolving the issue.

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=8476810696934790114

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=16489935144813831239

Answer 1

Hi sauravshandilya,

as I can see from your logs, there are some problems with your DB: the missing table knowagedb.QRTZ_TRIGGERS and the others table of Quartz is needed on the same schema of the Knowage tables. 

Could you please check if you have executed all the DB scripts listed in the following link?

https://knowage-suite.readthedocs.io/en/7.1/installation-guide/manual-installation.html

In particular, could you check if you executed the XXX_create_quartz_schema.sql?

If you don't have that file you can download it from the download page of Knowage, at the bottom, clicking on Metadata Database Scripts, choosing the right one for your DB.

Marco