topic Upgrade from 4.2.c to 4.2.f: Table 'ACT_RE_MODEL' already exists in Alfresco Archive

Upgrade from 4.2.c to 4.2.f: Table 'ACT_RE_MODEL' already exists

kjcsb — Thu, 08 May 2014 09:34:54 GMT

I am attempting to upgrade from Alfresco 4.2.c to 4.2.f.When I attempt to start Alfresco it attempts to upgrade the database schema and fails.I have backed up the contentstore etc and database, installed 4.2.f and restored.09:02:20,891 INFO [org.alfresco.repo.admin] Connected to database MySQL vers

Re: Upgrade from 4.2.c to 4.2.f: Table 'ACT_RE_MODEL' already exists

kaynezhang — Sat, 10 May 2014 02:01:00 GMT

activiti-upgrade-5-11.sql script is used to upgrade Activiti tables to 5.11 version,it seems table 'ACT_RE_MODEL' already exists when you attempted to upgrade from Alfresco 4.2.c to 4.2.f.

You can bypass the alfresco patch that upgrade Activiti tables to 5.11 and manually uprade Activiti tables.
You can try below steps:


1.Stop alfresco server
2.Executing SQL Statements in file ${TOMCAT_HOME}\webapps\alfresco\WEB-INF\classes\alfresco\dbscripts\upgrade\4.2\org.hibernate.dialect.MySQLInnoDBDialect\activiti-upgrade-5-11.sql using mysql command or source command.
3.make a backup of file ${TOMCAT_HOME}\webapps\alfresco\WEB-INF\classes\alfresco\dbscripts\upgrade\4.2\org.hibernate.dialect.MySQLInnoDBDialect\activiti-upgrade-5-11.sql
4.Clear all content in file ${TOMCAT_HOME}\webapps\alfresco\WEB-INF\classes\alfresco\dbscripts\upgrade\4.2\org.hibernate.dialect.MySQLInnoDBDialect\activiti-upgrade-5-11.sql
5.Start alfresco server again
6.restore file ${TOMCAT_HOME}\webapps\alfresco\WEB-INF\classes\alfresco\dbscripts\upgrade\4.2\org.hibernate.dialect.MySQLInnoDBDialect\activiti-upgrade-5-11.sql
‍‍‍‍‍‍‍‍

Re: Upgrade from 4.2.c to 4.2.f: Table 'ACT_RE_MODEL' already exists

kjcsb — Thu, 15 May 2014 05:38:58 GMT

Upgrade script used ${TRUE}
It turned out there was a problem with a number of the MySQL scripts - they attempted to use variable ${TRUE} which didn't work on the version on MySQL that I'm using. So I updated the script dropped and recreated the database, reimported the database from Alfresco 4.2.c and then the upgrade worked correctly.

For example from
INSERT INTO alf_applied_patch
(id, description, fixes_from_schema, fixes_to_schema, applied_to_schema, target_schema, applied_on_date, applied_to_server, was_executed, succeeded, report)
VALUES
(
    'patch.db-V4.2-upgrade-to-activiti-5.10', 'Manually executed script upgrade V4.2: Upgraded Activiti tables to 5.10 version',
    0, 5111, -1, 5112, null, 'UNKNOWN', ${TRUE}, ${TRUE}, 'Script completed'
);

To

INSERT INTO alf_applied_patch
(id, description, fixes_from_schema, fixes_to_schema, applied_to_schema, target_schema, applied_on_date, applied_to_server, was_executed, succeeded, report)
VALUES
(
    'patch.db-V4.2-upgrade-to-activiti-5.10', 'Manually executed script upgrade V4.2: Upgraded Activiti tables to 5.10 version',
    0, 5111, -1, 5112, null, 'UNKNOWN', TRUE, TRUE, 'Script completed'
);