Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

Console Errors

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

Page 1 of 1

Console Errors

PostPosted:Fri Aug 13, 2010 10:04 am
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

PostPosted:Fri Aug 13, 2010 11:02 am
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

PostPosted:Fri Aug 13, 2010 11:37 am
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

PostPosted:Fri Aug 13, 2010 11:48 am
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

PostPosted:Fri Aug 13, 2010 11:58 am
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

PostPosted:Sat Aug 14, 2010 2:55 pm
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

PostPosted:Mon Aug 30, 2010 6:47 am
by pavila
OpenKM 5.0 is actually not recommended for production usage. We will release an stable version soon.

Re: Console Errors

PostPosted:Mon Aug 30, 2010 1:04 pm
by rmartinez
We get this error in OpenKM 4.1.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited