• Login failed

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #17000  by perdix
 
Hi Guys

I just did a fresh install of OpenKM 6.0 Professional Trail on Ubuntu 12.04 server. The installation went well and I could start using the system immediated. I created some profiles, users and uploaded all my documents all without problems.

I then decided to reboot the server to ensure that everything is working correctly. I'm now simply greated with with following message (I'm not even asked for a username and password):
Code: Select all
  Application error
  Class:	javax.servlet.ServletException
  Message:	com.openkm.core.DatabaseException: could not execute query
  Date:	Mon Jun 25 15:58:15 SAST 2012
  [Return]
I looked in the logs, specifically this file: /opt/openkm-6.0/tomcat/logs/localhost.log
I found the following interesting entry:
Code: Select all
2012-06-25 15:58:15,652 [http-bio-8080-exec-7] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp] - Servlet.service() for servlet [jsp] in context with path [/OpenKM] threw exception [javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query] with root cause
org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_LANGUAGE
Any advice?

Regards
Charl
 #17014  by jllort
 
seems grants privileges I see this kind of error when you execute as root and then try as normal user.

Try sudo chown -Rf user:user openkm-6.0.0

Tell us if it solves the problem
 #18524  by itiec
 
Got the same error.
Fresh install of OS, it works fine. i shut it down and when i start it, got this error.
using OpenKM Pro 6.0.1. Linux x64 platform
some okmdb files are created: .log, .script and .properties

any idea ?
thks
 #18532  by jllort
 
It think is a security problem of the user who's creating the database or which you're starting the application. Always are you starting the application on the same way ?
 #27921  by kumbulanit
 
i am on openkm 6.0 and also experiencing this message when i try and access the application
Code: Select all
Application error

Class:	org.apache.jasper.JasperException
Message:	javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query
Date:	Tue Feb 25 09:36:15 SAST 2014
i checked the log file and it gave me an error with OKM_LANGUAGE

how can i solve this
 #27936  by jllort
 
You got version 6 in production and then you get this error or is clean instalallation ?
 #28004  by kumbulanit
 
jllort wrote:You got version 6 in production and then you get this error or is clean instalallation ?
i have it production and i am getting that error
 #28025  by jllort
 
stop tomcat
remove all log files
start tomcat and try login
stop tomcat and share here the log
 #44853  by jimac
 
I'm having the same problem here. Any solutions already?
 #44854  by jimac
 
I'm having the same problem. Any solutions in this topic already?
 #44899  by jimac
 
Hi!

It was installed last January, it's a OpenKM 6.3.2 It was a task that is assigned to me to repair this kind of error.
 #44911  by jllort
 
What is the content of your OpenKM.cfg ( the file is into tomcat folder ). I suspect is not able to connect to the database.
 #44921  by jimac
 
Good Day!

Here's my OpenKM.cfg
Code: Select all
# OpenKM Hibernate configuration values
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.hbm2ddl=none

# Initial configuration - Linux
system.imagemagick.convert=/usr/bin/convert
system.openoffice.path=/usr/lib/libreoffice
system.swftools.pdf2swf=/opt/openkm/bin/pdf2swf -f -T 9 -t -s storeallcharacters ${fileIn} -o ${fileOut}

# Initial configuration - Windows
#system.imagemagick.convert=C:/openkm/bin/convert.exe
#system.openoffice.path=C:/Program Files (x86)/OpenOffice 4
#system.swftools.pdf2swf=C:/openkm/bin/pdf2swf.exe -f -T 9 -t -s storeallcharacters ${fileIn} -o ${fileOut}
Thank You in Advance
 #44922  by jimac
 
On the last part of my Catalina.log is this:
Code: Select all
2017-11-20 17:05:24,273 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.3//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.3.dtd)
2017-11-20 17:05:24,274 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- resolveEntity(publicId=-//OpenKM//DTD Property Groups 2.1//EN, systemId=http://www.openkm.com/dtd/property-groups-2.1.dtd) => /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-2.1.dtd
2017-11-20 17:05:24,378 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,379 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-20 17:05:24,385 [localhost-startStop-1] ERROR com.openkm.bean.form.Select- Unable to get key values for Select
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:377)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:250)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:236)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:78)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:91)
	at com.openkm.bean.form.Select.getOptionsFromDb(Select.java:197)
	at com.openkm.bean.form.Select.handleDbOptions(Select.java:160)
	at com.openkm.bean.form.Select.setOptions(Select.java:61)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:553)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:198)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:110)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:371)
	... 27 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	... 35 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 46 more
2017-11-20 17:05:24,398 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,398 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-20 17:05:24,398 [localhost-startStop-1] ERROR com.openkm.bean.form.Select- Unable to get key values for Select
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:377)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:250)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:236)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:78)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:91)
	at com.openkm.bean.form.Select.getOptionsFromDb(Select.java:197)
	at com.openkm.bean.form.Select.handleDbOptions(Select.java:160)
	at com.openkm.bean.form.Select.setOptions(Select.java:61)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:553)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:198)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:110)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:371)
	... 27 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	... 35 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 46 more
2017-11-20 17:05:24,402 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,402 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-20 17:05:24,402 [localhost-startStop-1] ERROR com.openkm.bean.form.Select- Unable to get key values for Select
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:377)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:250)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:236)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:78)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:91)
	at com.openkm.bean.form.Select.getOptionsFromDb(Select.java:197)
	at com.openkm.bean.form.Select.handleDbOptions(Select.java:160)
	at com.openkm.bean.form.Select.setOptions(Select.java:61)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:553)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:198)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:110)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:371)
	... 27 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	... 35 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 46 more
2017-11-20 17:05:24,442 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Initialize language detection engine... ***
2017-11-20 17:05:24,812 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,812 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_CONFIG
2017-11-20 17:05:24,812 [localhost-startStop-1] ERROR com.openkm.core.Config- ** Error reading configuration table **
2017-11-20 17:05:24,813 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Repository initializing... ***
2017-11-20 17:05:24,825 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,825 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_NODE_BASE
2017-11-20 17:05:24,825 [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
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
	at com.openkm.dao.NodeBaseDAO.calculateUuidFromPath(NodeBaseDAO.java:261)
	at com.openkm.dao.NodeBaseDAO.calculateUuidFromPath(NodeBaseDAO.java:232)
	at com.openkm.dao.NodeBaseDAO.getUuidFromPath(NodeBaseDAO.java:122)
	at com.openkm.module.db.DbRepositoryModule.create(DbRepositoryModule.java:112)
	at com.openkm.module.db.DbRepositoryModule.initialize(DbRepositoryModule.java:85)
	at com.openkm.servlet.RepositoryStartupServlet.start(RepositoryStartupServlet.java:175)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:127)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
2017-11-20 17:05:24,919 [localhost-startStop-1] WARN  org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet- CMIS version is not defined! Setting it to CMIS 1.0.
2017-11-20 17:05:24,956 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/ROOT
2017-11-20 17:05:25,803 [main] INFO  org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-11-20 17:05:25,825 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8109"]
2017-11-20 17:05:25,847 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 42418 ms
2017-11-20 17:05:26,353 [http-bio-0.0.0.0-8080-exec-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader- Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2017-11-20 17:05:26,436 [http-bio-0.0.0.0-8080-exec-1] INFO  org.springframework.jdbc.support.SQLErrorCodesFactory- SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2017-11-20 17:05:26,443 [http-bio-0.0.0.0-8080-exec-1] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
2017-11-20 17:05:47,148 [http-bio-0.0.0.0-8080-exec-2] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
2017-11-20 17:06:47,332 [http-bio-0.0.0.0-8080-exec-3] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
2017-11-20 17:07:47,537 [http-bio-0.0.0.0-8080-exec-4] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
Thank You.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.