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

[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

[Ethan.Yang]

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









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.

[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