topic Problem during schema upgrade in Alfresco Archive

Problem during schema upgrade

mikepoole — Mon, 18 Jun 2012 08:36:51 GMT

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 dbSchemaUpgradeINFO: upgrading activiti engine schema

Re: Problem during schema upgrade

frederikherema1 — Mon, 18 Jun 2012 08:59:55 GMT

Seems like the upgrade is already done bot your database is still marked as 5.8. You should validate all upgrades have taken place (see the files you mentioned in your post) on the DB. if so, it'w safe to change the version of your engine to 5.9 (in ACT_GE_PROPERTIES).

BEWARE: this is not something you just do on a production database, make sure all upgrades have been performed correctly…

Re: Problem during schema upgrade

mikepoole — Mon, 18 Jun 2012 09:30:26 GMT

Frederick

Thanks for the reply

I'm slightly confused. How do I get to the ACT_GE_PROPERTIES table to change the version? When I do ant demo.start, I get all the version errors and therefore cannot open Activiti Explorer on localhost:8080

Regards

Mike

Re: Problem during schema upgrade

frederikherema1 — Mon, 18 Jun 2012 09:38:09 GMT

In the ACT_GE_PROPERTIES there is a schema.version property, containing in your case 5.8. Be sure to check ALL upgrade-sql's have been performed before changing

Re: Problem during schema upgrade

mikepoole — Mon, 18 Jun 2012 09:51:13 GMT

But if I can't open Activiti Explorer and log in as kermit, ho can I view/amend the ACT_GE_PROPERTIES table/schema-version?

Sorry for my ignorance on this matter. I can't see this table in the h2.console

Thanks for your time

Mike

Re: Problem during schema upgrade

mikepoole — Mon, 18 Jun 2012 09:55:09 GMT

Sorry Frederik - please ignore my last post

Had forgotten to emand the h2 console URL to jdbc:h2:tcp://localhost/activiti

D'oh!

Mike