Page 1 of 1

javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

PostPosted:Fri Nov 01, 2024 9:36 am
by Ethan.Yang
I am currently using OpenKM 6.3.0 Community Edition on the following system:
- Operating System: Linux Mint 21.3

I am mainly encountering the error: javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query.

Upon checking the logs, I see numerous errors related to creating tables. Here is one example:
Code: Select all
2024-11-01 15:38:22,379 [localhost-startStop-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport- Unsuccessful:
 create table JBPM_ACTION (ID_ bigint not null auto_increment, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) ENGINE=InnoDB
Code: Select all
2024-11-01 15:38:22,815 [localhost-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Servlet /OpenKM threw load() exception
org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_NODE_BASE

Re: javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

PostPosted:Fri Nov 01, 2024 9:39 am
by Ethan.Yang
Image



I have confirmed that MySQL has created a database and user successfully.

Image
Image






Additionally, I need help resolving an issue with the preview feature. I successfully activated OpenKM before installing MySQL, but later I realized that I needed to install MySQL, so I removed OpenKM completely and started over.

https://forum.openkm.com/viewtopic.php?t=25011


I have spent several days researching this issue. My English is not good, and I rely on translation to read everything. I really need the OpenKM system to work. :cry: :cry: :cry:

Re: javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

PostPosted:Tue Nov 05, 2024 3:53 pm
by jllort
It is strange the driver which raises the exception is the HSQL ( ensure you have only one connection definition enabled in the server.xml file ):
Code: Select all
org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_NODE_BASE