cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco Community Upgrade

henrydl
Champ in-the-making
Champ in-the-making
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 UserSmiley Frustratedystem 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
2 REPLIES 2

mrogers
Star Contributor
Star Contributor
Are you using AVM?   If not then there's no need to run that patch.

henrydl
Champ in-the-making
Champ in-the-making
Many thanks Mrogers,
How can i disable this patch?
Henry