AnsweredAssumed Answered

Issue while creating multitenant configuration with postgres in activiti 6 beta4

Question asked by sreekanth on Sep 9, 2016
Getting the below exception while starting freshly with activiti 6 with multi tenant configuration, were i can see in pgadmin 28 tables are created including the one which shows in exception too.

03:18:13,754 INFO  [org.activiti.engine.compatibility.DefaultActiviti5CompatibilityHandlerFactory] (ServerService Thread Pool – 25)   Activiti 5 compatibility handler implementation not found or error during instantiation : org.activiti.compatibility.DefaultActiviti5CompatibilityHandler from [Module "deployment.process.war:main" from Service Module Loader]. Activiti 5 backwards compatibility disabled.
03:18:13,758 INFO  [org.activiti.engine.impl.ProcessEngineImpl] (ServerService Thread Pool – 25)   ProcessEngine default created
03:18:13,774 INFO  [org.activiti.engine.impl.cfg.multitenant.MultiSchemaMultiTenantProcessEngineConfiguration] (ServerService Thread Pool – 25)   creating/validating database schema for tenant public
03:18:13,896 INFO  [org.activiti.engine.impl.db.DbSqlSession] (ServerService Thread Pool – 25)   performing drop on engine with resource org/activiti/db/drop/activiti.postgres.drop.engine.sql
03:18:13,910 INFO  [org.activiti.engine.impl.db.DbSqlSession] (ServerService Thread Pool – 25)   performing drop on history with resource org/activiti/db/drop/activiti.postgres.drop.history.sql
03:18:13,917 INFO  [org.activiti.engine.impl.db.DbSqlSession] (ServerService Thread Pool – 25)   performing drop on identity with resource org/activiti/db/drop/activiti.postgres.drop.identity.sql
03:18:13,929 INFO  [org.activiti.engine.impl.db.DbSqlSession] (ServerService Thread Pool – 25)   performing create on engine with resource org/activiti/db/create/activiti.postgres.create.engine.sql
03:18:18,238 INFO  [org.activiti.engine.impl.db.DbSqlSession] (ServerService Thread Pool – 25)   performing create on history with resource org/activiti/db/create/activiti.postgres.create.history.sql
03:18:19,998 INFO  [org.activiti.engine.impl.db.DbSqlSession] (ServerService Thread Pool – 25)   performing create on identity with resource org/activiti/db/create/activiti.postgres.create.identity.sql
03:18:20,534 INFO  [org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor] (ServerService Thread Pool – 25)   Starting up the default async job executor [org.activiti.engine.impl.asyncexecutor.multitenant.SharedExecutorServiceAsyncExecutor].
03:18:20,536 INFO  [org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor] (ServerService Thread Pool – 25)   Creating thread pool queue of size 100
03:18:20,536 INFO  [org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor] (ServerService Thread Pool – 25)   Creating executor service with corePoolSize 2, maxPoolSize 10 and keepAliveTime 5000
03:18:20,539 INFO  [org.activiti.engine.impl.asyncexecutor.AcquireAsyncJobsDueRunnable] (Thread-95)   {} starting to acquire async jobs due
03:18:20,539 INFO  [org.activiti.engine.impl.asyncexecutor.AcquireTimerJobsRunnable] (Thread-94)   {} starting to acquire async jobs due
03:18:20,541 INFO  [org.activiti.engine.impl.asyncexecutor.AcquireTimerJobsRunnable] (Thread-96)   {} starting to acquire async jobs due
03:18:20,546 INFO  [org.activiti.engine.impl.asyncexecutor.ResetExpiredJobsRunnable] (Thread-97)   {} starting to reset expired jobs
03:18:20,604 ERROR [org.activiti.engine.impl.interceptor.CommandContext] (activiti-acquire-timer-jobs)   Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: relation "act_ru_timer_job" does not exist
  Position: 25
### The error may exist in org/activiti/db/mapping/entity/TimerJob.xml
### The error may involve org.activiti.engine.impl.persistence.entity.TimerJobEntityImpl.selectTimerJobsToExecute-Inline
### The error occurred while setting parameters
### SQL: select   RES.*     from ACT_RU_TIMER_JOB RES   where DUEDATE_ <= ?    and LOCK_OWNER_ is null    LIMIT ? OFFSET ?
### Cause: org.postgresql.util.PSQLException: ERROR: relation "act_ru_timer_job" does not exist
  Position: 25
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
   at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:318)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:303)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:293)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:258)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:252)
   at org.activiti.engine.impl.persistence.entity.data.impl.MybatisTimerJobDataManager.findTimerJobsToExecute(MybatisTimerJobDataManager.java:69)
   at org.activiti.engine.impl.persistence.entity.TimerJobEntityManagerImpl.findTimerJobsToExecute(TimerJobEntityManagerImpl.java:70)
   at org.activiti.engine.impl.cmd.AcquireTimerJobsCmd.execute(AcquireTimerJobsCmd.java:40)
   at org.activiti.engine.impl.cmd.AcquireTimerJobsCmd.execute(AcquireTimerJobsCmd.java:29)
   at org.activiti.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:38)
   at org.activiti.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:79)
   at org.activiti.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:58)
   at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:43)
   at org.activiti.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:48)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:63)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:29)
   at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:44)
   at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:39)
   at org.activiti.engine.impl.asyncexecutor.AcquireTimerJobsRunnable.run(AcquireTimerJobsRunnable.java:57)
   at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "act_ru_timer_job" does not exist
  Position: 25
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
   at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
   at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
   at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
   at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:303)
   at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
   … 21 more

Outcomes