topic Re: Upgrade Alfresco from 5.1 to 6.2 in Alfresco Forum

Upgrade Alfresco from 5.1 to 6.2

majastojanova — Fri, 22 Oct 2021 11:46:38 GMT

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:

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.

Re: Upgrade Alfresco from 5.1 to 6.2

angelborroy — Fri, 22 Oct 2021 14:10:03 GMT

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/alfresco/dbscripts/upgrade

Re: Upgrade Alfresco from 5.1 to 6.2

majastojanova — Tue, 07 Dec 2021 14:13:07 GMT

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/alfresco/dbscripts/upgrade/5.1/org.alfresco.repo.domain.dialect.PostgreSQLDialect

and

https://github.com/Alfresco/alfresco-community-repo/tree/master/repository/src/main/resources/alfresco/dbscripts/upgrade/6.0/org.alfresco.repo.domain.dialect.Dialect

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.

Re: Upgrade Alfresco from 5.1 to 6.2

majastojanova — Thu, 09 Dec 2021 14:38:43 GMT

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

Re: Upgrade Alfresco from 5.1 to 6.2

AlfrescoZZZ — Fri, 07 Oct 2022 11:14:51 GMT

Same issue here, did you find a solution ?