topic Alfresco Community Upgrade in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297241#M250371 <HTML><HEAD></HEAD><BODY><SPAN>I'm trying to upgrade Alfresco2.1 Community to Alfresco3.0 Community (with Postgres Database)</SPAN><BR /><SPAN>First of all i don't find the scripts for the Postgres Upgrade (org.hibernate.dialect.PostgreSQLDialect) in </SPAN><BR /><BR /><SPAN>tomcat/webapps/alfresco/WEB-INF/classes/alfresco/dbscripts/upgrade/2.2/</SPAN><BR /><BR /><SPAN>So i have copied them from a Alfresco 3.2 installation.</SPAN><BR /><BR /><SPAN>Then i have:</SPAN><BR /><SPAN>- Installed Alfresco3.0 , launched and stopped to test if works </SPAN><BR /><SPAN>- Stopped Alfresco2.1</SPAN><BR /><SPAN>- Backed up Alfresco2.1 database with pg_dump</SPAN><BR /><SPAN>- Deleted all data in Alfresco3.0/alf_data directory</SPAN><BR /><SPAN>- Deleted Alfresco3.0 database</SPAN><BR /><SPAN>- Recreated Alfresco3.0 database and restored Alfresco2.1 backup</SPAN><BR /><SPAN>- Copied Alfresco2.1/alf_data/contentstore in Alfresco3.0/alf_data</SPAN><BR /><SPAN>- Launched Alfresco3.0</SPAN><BR /><SPAN>- All updates seems succesful, index are recreated, but finally i have this error:</SPAN><BR /><BR /><BR /><SPAN>17:31:57,525 User<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ystem ERROR [admin.patch.PatchExecuter] </SPAN><BR /><SPAN>=== Failed to apply patch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; === </SPAN><BR /><SPAN>ID: patch.updateAvmPermissions</SPAN><BR /><SPAN>RESULT: </SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Failed to set TX isolation level</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.AclDaoComponentImpl.getAVMHeadNodeCount(AclDaoComponentImpl.java:2019)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.impl.AVMPermissionsPatch.applyInternal(AVMPermissionsPatch.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:382)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:414)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:378)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:418…</SPAN><BR /><BR /><BR /><SPAN>Could you help me?</SPAN><BR /><SPAN>Thanks in advance</SPAN><BR /><SPAN>Henry</SPAN></BODY></HTML> Tue, 18 Aug 2015 14:29:17 GMT henrydl 2015-08-18T14:29:17Z Alfresco Community Upgrade https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297241#M250371 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 Tue, 18 Aug 2015 14:29:17 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297241#M250371 henrydl 2015-08-18T14:29:17Z Re: Alfresco Community Upgrade https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297242#M250372 <HTML><HEAD></HEAD><BODY><SPAN>Are you using AVM?&nbsp;&nbsp; If not then there's no need to run that patch.</SPAN></BODY></HTML> Tue, 18 Aug 2015 16:19:34 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297242#M250372 mrogers 2015-08-18T16:19:34Z Re: Alfresco Community Upgrade https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297243#M250373 <HTML><HEAD></HEAD><BODY><SPAN>Many thanks Mrogers,</SPAN><BR /><SPAN>How can i disable this patch?</SPAN><BR /><SPAN>Henry</SPAN></BODY></HTML> Wed, 19 Aug 2015 07:06:02 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-community-upgrade/m-p/297243#M250373 henrydl 2015-08-19T07:06:02Z