Online demo
Download
Contact

Because information matters

  • Console Errors

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
It is currently Tue Jun 17, 2025 8:29 pm

Console Errors

OpenKM has many interesting features, but requires some configuration process to show its full potential.
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.
 Reply

Console Errors

 #6147  by aman014
 
Hi I have deployed openKM on a remote server and made it connect to mySQL database locally everything is working fine, however if i leave the server ideal for a few days and i log in as okmAdmin i get loads of errors, but if restart the server it works fine, then again if i leave the application ideal there are errors, here are a list of errors in the console..
Code: Select all
15:40:19,359 INFO  [RepositoryImpl] Starting repository...
15:40:19,421 INFO  [LocalFileSystem] LocalFileSystem initialized at path D:\OpenKM-4.1_JBoss-4.2.3.GA\repository\repository
15:40:19,750 INFO  [LocalFileSystem] LocalFileSystem initialized at path D:\OpenKM-4.1_JBoss-4.2.3.GA\repository\version
15:40:21,406 INFO  [ConnectionRecoveryManager] Database: Apache Derby / 10.2.1.6 - (452058)
15:40:21,406 INFO  [ConnectionRecoveryManager] Driver: Apache Derby Embedded JDBC Driver / 10.2.1.6 - (452058)
15:40:22,781 INFO  [RepositoryImpl] initializing workspace 'default'...
15:40:22,781 INFO  [LocalFileSystem] LocalFileSystem initialized at path D:\OpenKM-4.1_JBoss-4.2.3.GA\repository\workspaces\default
15:40:22,843 INFO  [ConnectionRecoveryManager] Database: Apache Derby / 10.2.1.6 - (452058)
15:40:22,843 INFO  [ConnectionRecoveryManager] Driver: Apache Derby Embedded JDBC Driver / 10.2.1.6 - (452058)
15:40:23,265 INFO  [RepositoryImpl] workspace 'default' initialized
15:40:23,765 INFO  [LocalFileSystem] LocalFileSystem initialized at path D:\OpenKM-4.1_JBoss-4.2.3.GA\repository\workspaces\default\index
15:40:24,156 INFO  [SearchIndex] Index initialized: D:\OpenKM-4.1_JBoss-4.2.3.GA\repository\workspaces\default/index Version: 2
15:40:24,156 INFO  [RepositoryImpl] Repository started
15:40:33,953 INFO  [SimpleWebdavServlet] resource-path-prefix = '/repository'
15:40:34,703 INFO  [SimpleWebdavServlet] WWW-Authenticate header = 'Basic realm="OpenKM Webdav Server"'
15:40:34,031 WARN  [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
15:40:34,703 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers
ion for the right syntax to use near '1 job0_.ID_ as ID1_22_, job0_.VERSION_ as VERSION3_22_, job0_.DUEDATE_ as DUEDAT' at line 1
15:40:34,718 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
15:40:34,734 ERROR [JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:43)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:114)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:58)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2223)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:39)
        ... 2 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that correspond
s to your MySQL server version for the right syntax to use near '1 job0_.ID_ as ID1_22_, job0_.VERSION_ as VERSION3_22_, job0_.DUEDATE_ as D
UEDAT' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2237)
        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        ... 11 more
15:40:39,828 WARN  [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
15:40:39,859 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers
ion for the right syntax to use near '1 job0_.ID_ as ID1_22_, job0_.VERSION_ as VERSION3_22_, job0_.DUEDATE_ as DUEDAT' at line 1
15:40:39,859 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
15:40:39,859 ERROR [JobExecutorThread] exception in job executor thread. waiting 10000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:43)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:114)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:58)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2223)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:39)
        ... 2 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that correspond
s to your MySQL server version for the right syntax to use near '1 job0_.ID_ as ID1_22_, job0_.VERSION_ as VERSION3_22_, job0_.DUEDATE_ as D
UEDAT' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2237)
        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        ... 11 more
Please help me with a solution to this.. Thanks

Re: Console Errors

 #6149  by rmartinez
 
We got the same error, I think OpenKM only works with HypesonicDB for jBPM.

We have made changes in hibernate.cfg.xml, in order to use MySQl database:

<!--<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>-->
<property name="hibernate.dialect">MySQL5InnoDBDialect</property>

but we got errors as well.

Finally, we have made changes in openkm-ds.xml for working with Hypersonic database (by default in the openkm 4.1 distribution) and all work fine.

Re: Console Errors

 #6150  by aman014
 
So your trying to tell me we cant get openKm to work with MySQL Database, this is not possible i think...

Re: Console Errors

 #6151  by rmartinez
 
OpenKM has multiple datasources. You can get OpenKM to work with MySQL for:

A. Repository -> Configuring repository.xml
B. OKMActivityDS, OKMAuthDS, OKMDashboardStatsDS -> Configuring openkm-ds.xml

But OKMWorkflowDS only works with Hypersonic database.

Re: Console Errors

 #6152  by aman014
 
Oh ok so what is the best solution, just make OKMWorkFlow connect to hypersonic database will this work, while the others are connected to MySQL?

Re: Console Errors

 #6162  by rmartinez
 
I don't know if this is the best solution, but it is the solution that worked for us in order to use MySQL in various datasources in openKM.

Re: Console Errors

 #6337  by pavila
 
OpenKM 5.0 is actually not recommended for production usage. We will release an stable version soon.

Re: Console Errors

 #6342  by rmartinez
 
We get this error in OpenKM 4.1.
 Reply
 Return to “Configuration”

Favorites

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.

Powered By phpBB -
 ©OpenKM 2021
 - All times are UTC -