topic Re: Upgrade from 4.2.d to 201602 fails in Alfresco Archive

Upgrade from 4.2.d to 201602 fails

hoomanv — Sun, 13 Mar 2016 15:27:41 GMT

Hi,v1 = 4.2.d communityv2 = 201602 communitySteps:1) Cleanly installed v2 and it worked.2) Dropped database and deleted the contentstore, contentstore.deleted directories of v23) Recreated v2 database and restored v1 db.dump on it4) Copied contentstore, contentstore.deleted dirs of v1 to v25) Starte

Re: Upgrade from 4.2.d to 201602 fails

afaust — Wed, 16 Mar 2016 12:22:55 GMT

Hello,

upgrading Community versions is not always possible from any version to the newest version in just one step. You might want to try doing sequential upgrades, e.g. from 4.2.d to 4.2.f (latest on 4.2 line), then to 5.0.d and then to latest 5.1 / GA.

The specific error in your case appears to the result of a too optimistic schema patch which expected a specific DB structure to exist (most likely one that 5.0.x might have introduced). This may also be the result of an error in 4.2.d which may not have included a performance-relevant constraint / index. This issue would be one of the common reasons to do the upgrade in multiple steps.

Regards
Axel

Re: Upgrade from 4.2.d to 201602 fails

hoomanv — Sat, 20 Jan 2018 08:44:28 GMT

I'm back after 2 years, trying to give it another try.

So far, I have gone through this upgrade path successfully: 4.2.d >> 4.2.f >> 5.0.a

Trying to upgrade 5.0.a to 5.0.d gives me the exact same error:

> constraint "act_ru_execution_proc_def_id__business_key__key" of relation "act_ru_execution" does not exist

So I'm considering either 5.0.b or 5.0.c if I get lucky.

Re: Upgrade from 4.2.d to 201602 fails

hoomanv — Sat, 20 Jan 2018 11:23:19 GMT

Upgrade from 5.0.a to 5.0.c failed with the same error.

Then I found Upgrade from 4.1.3 to 5.0 and executed the SQL statements below:

ALTER INDEX act_ru_execution_proc_def_id__key RENAME TO act_ru_execution_proc_def_id__business_key__key;
ALTER INDEX act_hi_procinst_proc_def_id__key RENAME TO act_hi_procinst_proc_def_id__business_key__key;

Which solved the problem of upgrading 5.0.a directly to 5.0.d

Re: Upgrade from 4.2.d to 201602 fails

douglascrp — Sat, 20 Jan 2018 12:37:06 GMT

You were using the version 5.0.a, which was a kind of "experimental" version, as mentioned in the release notes: Alfresco Community 5.0.a Release Notes

Being the first community release for 5.0, this has undergone limited testing and care should taken before upgrading any previous Alfresco Community version with this version.

And saying that the path is not documented, I can not agree with that: Alfresco Content Services upgrade paths | Alfresco Documentation