topic Problems with schema update in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problems-with-schema-update/m-p/57537#M35003 <HTML><HEAD></HEAD><BODY><SPAN>I have updated from activiti 5.5 to 5.7 resulting in the following entry in act_ge_property:</SPAN><BR /><BR /><SPAN>"schema.history","create(5.5) upgrade(5.5-&gt;5.7)"</SPAN><BR /><BR /><SPAN>I connected with this database with an older version of my application resulting in the following entry in act_ge_property:</SPAN><BR /><SPAN>"schema.history", "create(5.5) upgrade(5.5-&gt;5.7) upgrade(5.7-&gt;5.5)"</SPAN><BR /><BR /><SPAN>and the schema is 5.5 again:</SPAN><BR /><SPAN>"schema.version", "5.5"</SPAN><BR /><BR /><SPAN>Now if I connect to the same database again with the 5.7 version, I get the following error:</SPAN><BR /><SPAN>Caused by: org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_HI_PROCINST add SUPER_PROCESS_INSTANCE_ID_ varchar(64)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:826)</SPAN><BR /><BR /><SPAN>Probably nothing happened when "upgrading" from 5.7 to 5.5 and I can simply edit "schema.version" to "5.7" again to work with 5.7. But is this the intended behaviour or should I create a JIRA-entry?</SPAN></BODY></HTML> Wed, 14 Sep 2011 08:55:35 GMT mdond 2011-09-14T08:55:35Z Problems with schema update https://connect.hyland.com/t5/alfresco-archive/problems-with-schema-update/m-p/57537#M35003 I have updated from activiti 5.5 to 5.7 resulting in the following entry in act_ge_property:"schema.history","create(5.5) upgrade(5.5-&gt;5.7)"I connected with this database with an older version of my application resulting in the following entry in act_ge_property:"schema.history", "create(5.5) upg Wed, 14 Sep 2011 08:55:35 GMT https://connect.hyland.com/t5/alfresco-archive/problems-with-schema-update/m-p/57537#M35003 mdond 2011-09-14T08:55:35Z Re: Problems with schema update https://connect.hyland.com/t5/alfresco-archive/problems-with-schema-update/m-p/57538#M35004 <HTML><HEAD></HEAD><BODY><SPAN>This is surely NOT the intended behavior. Afail, nothing changed during these releases… but it sure is strange you get some sql being updated then …</SPAN></BODY></HTML> Thu, 15 Sep 2011 13:19:43 GMT https://connect.hyland.com/t5/alfresco-archive/problems-with-schema-update/m-p/57538#M35004 jbarrez 2011-09-15T13:19:43Z