10-22-2021 04:46 AM
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:
./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
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.
10-22-2021 07:10 AM
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:
12-07-2021 06:13 AM
Hi, thank you for your response!
I have tried applying the patches to my postgres database from
and
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.
12-09-2021 06:38 AM
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
10-07-2022 04:14 AM
Same issue here, did you find a solution ?
Explore our Alfresco products with the links below. Use labels to filter content by product module.