Upgrade Alfresco from 5.1 to 6.2

[majastojanova]

Hello,

I am trying to migrate data from an Alfresco 5.1 server to an Alfresco 6.2 server. I have installed the 6.2 on a separate CentOS 7.9 server and installed Alfresco manually. The database is postgresql11-server-11.4. I have also installed my required AMPs, the server was running okay and without errors at this point.

According to these steps https://docs.alfresco.com/content-services/6.2/upgrade/#upgrade-process I concluded that I can migrate only contentstore, contentstore.deleted and the database and solr will take care of reindexing by itself.

The steps I have done are:

1. Backup database: (on 5.1)

./pg_dump -v -U alfresco alfresco > dumpfile.sql

    2.Backup contentstore: (on 5.1)

tar -czvf backup-contentstore.tar.gz contentstore contentstore.deleted

3. Restore data: (on 6.2)

• systemctl stop tomcat8@alfresco

• systemctl stop alfresco-search

• delete contentstore and contentstore.deleted folders from /opt/alfresco6/alf_data

• delete database

  su - postgres
  psql
  DROP database alfresco;
  create database alfresco encoding 'utf8';
  grant all on database alfresco to alfresco;\q

• delete folders /opt/alfresco6/alf_data/solr6/solrhome/AlfrescoModels and opt/alfresco6/alf_data/solr6/solrhome/archive/index
• restore backups: move contentstore, contentstore.deleted to /opt/alfresco6/alf_data
• restore database: 
  su - postgres

          psql -d alfresco -f /srv/dumpfile.sql

Server started with this error:

 ERROR [admin.patch.PatchExecuter] [localhost-startStop-1] 09220020 org.alfresco.error.AlfrescoRuntimeException: 09220019 Bootstrap failed      at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBoo
tstrap.java:367)        at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:130)       at org.alfresco.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:455)        at org.alfres
co.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:1)       at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)  at org.alfresco.repo.admin.patch.AbstractPatch.applyW
ithTxns(AbstractPatch.java:462) at org.alfresco.repo.admin.patch.AbstractPatch.access$0(AbstractPatch.java:442) at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:620) at org.alfresco.repo.admin.patch.AbstractPatc
h$4.doWork(AbstractPatch.java:1)        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:602)      at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:624)    at org.alfres
co.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:586) at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:564)       at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(P
atchServiceImpl.java:477)       at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:332) at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:309)  at org.alfres
co.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:198) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)       at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.in
voke(NativeMethodAccessorImpl.java:62)  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    

.....

org.springframework.dao.DataIntegrityViolationException:
### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
### The error may involve alfresco.appliedpatch.update_AppliedPatch-Inline
### The error occurred while setting parameters
### SQL: update alf_applied_patch             set                 description = ?,                 fixes_from_schema = ?,                 fixes_to_schema = ?,                 target_schema = ?,                 applied_to_schema = ?,
            applied_on_date = ?,                 applied_to_server = ?,                 was_executed = ?,                 succeeded = ?,                 report = ?             where                 id = ?
### Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
; ERROR: value too long for type character varying(1024); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)

What does this error indicate and am I doing something wrong in the steps of upgrading? Should I actually make the upgrade in-server? I am trying to avoid production server down time.

Any help would be appreciated.

Thank you.

[angelborroy]

You may try upgrading to 5.2 and after that upgrade to 6.2.

As reference, these are the DB patches that needs to be applied to upgrade Postgres DB from 5.1 to 6.2:

https://github.com/Alfresco/alfresco-community-repo/tree/master/repository/src/main/resources/alfres...

[majastojanova]

Hi, thank you for your response!

I have tried applying the patches to my postgres database from

https://github.com/Alfresco/alfresco-community-repo/tree/master/repository/src/main/resources/alfres...

and

https://github.com/Alfresco/alfresco-community-repo/tree/master/repository/src/main/resources/alfres...

and I got the following error in catalina.out when starting tomcat:

2021-12-06 13:28:25,363  INFO  [repo.admin.ConfigurationChecker] [localhost-startStop-1] The root data directory ('dir.root') is: /opt/alfresco6/alf_data
2021-12-06 13:28:25,389  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1] Checking for patches to apply ...
2021-12-06 13:28:25,758  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]      Applying patch 'patch.addInviteModeratedEmailTemplates' (Adds the email template for the invite moderated flow).
2021-12-06 13:28:26,508  ERROR [admin.patch.PatchExecuter] [localhost-startStop-1] 11060020 org.alfresco.error.AlfrescoRuntimeException: 11060019 Bootstrap failed      at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:367)        at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:130)       at org.alfresco.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:455)        at org.alfresco.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:1)       at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)  at org.alfresco.repo.admin.patch.AbstractPatch.applyWithTxns(AbstractPatch.java:462) at org.alfresco.repo.admin.patch.AbstractPatch.access$0(AbstractPatch.java:442) at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:620) at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:1)        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:602)      at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:624)    at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:586) at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:564)       at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(PatchServiceImpl.java:477)       at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:332) at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:309)  at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:198) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)       at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)     at java.base/java.lang.reflect.Method.invoke(Method.java:566)   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)  at com.sun.proxy.$Proxy131.applyOutstandingPatches(Unknown Source)      at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:83)   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:131)      at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:1)   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java

any ideas as of why this is happening? Do I have some inconsistencies in my migrated database and what do I have to delete/add to fix it?

I will also try upgrating to 5.2 and then to 6.2 if I don't solve this issue this way.

Thank you.

[majastojanova]

Hello,

thank you for your response.

I have tried applying the patches for 5.2 and 6.0 from the link you shared to me on my Postgres database and I have got the following error in catalina.out when starting tomcat:

2021-12-06 13:28:25,363  INFO  [repo.admin.ConfigurationChecker] [localhost-startStop-1] The root data directory ('dir.root') is: /opt/alfresco6/alf_data
2021-12-06 13:28:25,389  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1] Checking for patches to apply ...
2021-12-06 13:28:25,758  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]      Applying patch 'patch.addInviteModeratedEmailTemplates' (Adds the email template for the invite moderated flow).
2021-12-06 13:28:26,508  ERROR [admin.patch.PatchExecuter] [localhost-startStop-1] 11060020 org.alfresco.error.AlfrescoRuntimeException: 11060019 Bootstrap failed      at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:367)        at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:130)       at org.alfresco.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:455)        at org.alfresco.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:1)       at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)  at org.alfresco.repo.admin.patch.AbstractPatch.applyWithTxns(AbstractPatch.java:462) at org.alfresco.repo.admin.patch.AbstractPatch.access$0(AbstractPatch.java:442) at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:620) at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:1)        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:602)      at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:624)    at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:586) at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:564)       at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(PatchServiceImpl.java:477)       at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:332) at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:309)  at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:198) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)       at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)     at java.base/java.lang.reflect.Method.invoke(Method.java:566)   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)  at com.sun.proxy.$Proxy131.applyOutstandingPatches(Unknown Source)      at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:83)   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:131)      at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:1)   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java

Any idea what this error means?

Thank you and Best regards

[4535992]

Same issue here, did you find a solution ?