AnsweredAssumed Answered

Problem during schema upgrade

Question asked by mikepoole on Jun 18, 2012
Latest reply on Jun 18, 2012 by mikepoole
I recently amended my activiti-engine jar form 5.8 to 5.9 via Maven in Eclipse designer to fix another problem I was having.

Now when I attempt to run code, I kepe getting the following:

18-Jun-2012 09:30:44 org.activiti.engine.impl.db.DbSqlSession dbSchemaUpgrade
INFO: upgrading activiti engine schema from 5.8 to 5.9
18-Jun-2012 09:30:44 org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing upgrade on engine with resource org/activiti/db/upgrade/activiti.h2.upgradestep.58.to.59.engine.sql
18-Jun-2012 09:30:44 org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
SEVERE: problem during schema upgrade, statement 'alter table ACT_RU_EXECUTION
add SUSPENSION_STATE_ integer
org.h2.jdbc.JdbcSQLException: Duplicate column name "SUSPENSION_STATE_"; SQL statement:
alter table ACT_RU_EXECUTION
add SUSPENSION_STATE_ integer [42121-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
…and on and on….

What have I broken? Is there anything I can do to allow the schema upgrade to happen?

Many thanks

Mike

Outcomes