problem when hosted on linux debian 6 Squeze server

[pavan_bukka_ait]

Hi all,
       we are using activiti frame work for the implementation workflows in our application .when we deploy our application in tomcatserver on windows server 2003  everything is working fine , but when deploy in tomcat server on linux debian 6 Squeze server it is not working . i have attached the tomcat log i think from this you will get know what exactly is the problem.
For your information we have put all the tables in activiti database in our database named testdms.

with regards,
b pavan kumar.

SEVERE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activiti.ACT_RU_TASK' doesn't exist
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activiti.ACT_RU_TASK' doesn't exist
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:193)
   at org.activiti.engine.impl.persistence.entity.TaskManager.findTasksByQueryCriteria(TaskManager.java:91)
   at org.activiti.engine.impl.TaskQueryImpl.executeList(TaskQueryImpl.java:368)
   at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:138)
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activiti.ACT_RU_TASK' doesn't exist
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:525)


org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activiti.ACT_RU_TASK' doesn't exist
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activiti.ACT_RU_TASK' doesn't exist
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:193)
   at org.activiti.engine.impl.persistence.entity.TaskManager.findTasksByQueryCriteria(TaskManager.java:91)
   at org.activiti.engine.impl.TaskQueryImpl.executeList(TaskQueryImpl.java:368)
   at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:138)
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activiti.ACT_RU_TASK' doesn't exist
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
   at com.mysql.jdbc.Util.getInstance(Util.java:382)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
   at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
   at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)

[ronald_van_kuij]

Uhmmmm… Do you realy not see what the cause is?

[pavan_bukka_ait]

Hi Ronald.
             even though i have restored all the tables of activiti data base in my data base it is giving the error that tables are missing and also i have tried by putting separate data base for activiti and configured in the dispatcherservelet to use this database then also it is giving the same problem but works well in windows 2003 server not in linux .


kind regards,
b pavan kumar.

[ronald_van_kuij]

You have to do a lot more troubleshooting yourself… It is kind of impossible for us to check these things out via a magic glass ball (I don't have one 😉

Try things like: accessing the right database; the correct rights, the correct config file being used  etc etc etc…
Sorry…

[pavan_bukka_ait]

i have even changed the datasource of activiti my application's datasource but still it is giving the same problem ..

with regards,
b pavan kumar.