Database not create on manual installation = "ERROR: relation "sbi_config" does not exist" etc

Question

Hi all,

I am following the instructions as per https://knowage.readthedocs.io/en/6.1.1/admin/README/index.html#installation

I have created the data source & env variables in server.xml, copied the postgresql jar to the lib folder and edited the hibernate.cfg.xml and /quartz.properties  files. (The jbpm.hibernate.cfg.xml  file does not exist).

When tomcat start up I get errors in knowage.log to the effect that tables do not exist. I assumed hibernate would create theses when it started up the app. Do I need to run a script to create the tables?  If so where do I find the scripts? I know I had to do this with spagobi.

thanks

Answer 1

Hi,

Yes you have to create the table.

You can find scripts here

You can find all the documentation here

Best regards

Angelo

Comments

Be careful, the actual SQL file for Postgres is buggy. You need to add and empty line at the first line. See https://github.com/KnowageLabs/Knowage-Server/issues/51