Upgrade Alfresco from 5.1 to 6.2

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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