Code: Select all2017-11-10 11:09:04,017 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.2//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.2.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.2//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-2.2.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 1.1//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-1.1.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Report Parameters 2.0//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/report-parameters-2.0.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.1//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-2.1.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 1.1//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-1.1.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 1.0//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-1.0.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.4//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.4.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 1.0//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-1.0.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.3//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-2.3.dtd)
2017-11-10 11:09:04,018 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.1//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.1.dtd)
2017-11-10 11:09:04,019 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.0//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-2.0.dtd)
2017-11-10 11:09:04,019 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.5//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.5.dtd)
2017-11-10 11:09:04,019 [localhost-startStop-1] INFO com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.0//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.0.dtd)
2017-11-10 11:09:04,019 [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-10 11:09:04,020 [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-10 11:09:04,103 [localhost-startStop-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-10 11:09:04,103 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-10 11:09:04,105 [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-10 11:09:04,109 [localhost-startStop-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-10 11:09:04,109 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-10 11:09:04,109 [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-10 11:09:04,114 [localhost-startStop-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-10 11:09:04,114 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-10 11:09:04,114 [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-10 11:09:04,160 [localhost-startStop-1] INFO com.openkm.servlet.RepositoryStartupServlet- *** Initialize language detection engine... ***
2017-11-10 11:09:04,528 [localhost-startStop-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-10 11:09:04,528 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_CONFIG
2017-11-10 11:09:04,528 [localhost-startStop-1] ERROR com.openkm.core.Config- ** Error reading configuration table **
2017-11-10 11:09:04,528 [localhost-startStop-1] INFO com.openkm.servlet.RepositoryStartupServlet- *** Repository initializing... ***
2017-11-10 11:09:04,540 [localhost-startStop-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-10 11:09:04,540 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_NODE_BASE
2017-11-10 11:09:04,541 [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-10 11:09:04,574 [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-10 11:09:04,606 [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-10 11:09:05,508 [main] INFO org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-11-10 11:09:05,528 [main] INFO org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8109"]
2017-11-10 11:09:05,540 [main] INFO org.apache.catalina.startup.Catalina- Server startup in 42051 ms
2017-11-10 11:09:08,956 [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-10 11:09:09,015 [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-10 11:09:09,022 [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-10 11:10:08,839 [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-10 11:11:09,014 [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-10 11:12:08,207 [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