AnsweredAssumed Answered

Alfresco Community Upgrade

Question asked by henrydl on Aug 18, 2015
Latest reply on Aug 19, 2015 by henrydl
I'm trying to upgrade Alfresco2.1 Community to Alfresco3.0 Community (with Postgres Database)
First of all i don't find the scripts for the Postgres Upgrade (org.hibernate.dialect.PostgreSQLDialect) in

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/dbscripts/upgrade/2.2/

So i have copied them from a Alfresco 3.2 installation.

Then i have:
- Installed Alfresco3.0 , launched and stopped to test if works
- Stopped Alfresco2.1
- Backed up Alfresco2.1 database with pg_dump
- Deleted all data in Alfresco3.0/alf_data directory
- Deleted Alfresco3.0 database
- Recreated Alfresco3.0 database and restored Alfresco2.1 backup
- Copied Alfresco2.1/alf_data/contentstore in Alfresco3.0/alf_data
- Launched Alfresco3.0
- All updates seems succesful, index are recreated, but finally i have this error:


17:31:57,525 User:System ERROR [admin.patch.PatchExecuter]
=== Failed to apply patch         ===
ID: patch.updateAvmPermissions
RESULT:
org.alfresco.error.AlfrescoRuntimeException: Failed to set TX isolation level
   at org.alfresco.repo.domain.hibernate.AclDaoComponentImpl.getAVMHeadNodeCount(AclDaoComponentImpl.java:2019)
   at org.alfresco.repo.admin.patch.impl.AVMPermissionsPatch.applyInternal(AVMPermissionsPatch.java:55)
   at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:388)
   at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:382)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)
   at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:414)
   at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:378)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)
   at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:418…


Could you help me?
Thanks in advance
Henry

Outcomes