topic 'Failed to apply patch' -- what to do now? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/failed-to-apply-patch-what-to-do-now/m-p/226611#M179741 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I was following the backup &amp; restore procedures </SPAN><A href="http://wiki.alfresco.com/wiki/Backup_and_Restore" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Backup_and_Restore</A><SPAN> to try to get a new alfresco 3.2r installation to "come up with" the data from my old alfresco labs3d installation.&nbsp; I had a tarball of the alf_data and a mysqldump of the database, so I:</SPAN><BR /><BR /><SPAN> * shut down alfresco 32r</SPAN><BR /><SPAN> * rm -rf alf_data</SPAN><BR /><SPAN> * drop database alfresco; create database alfresco; source /tmp/old_labs3d_data.sql</SPAN><BR /><SPAN> * tar xvf /tmp/old_labs3d.tar</SPAN><BR /><SPAN> * start up alfresco32r</SPAN><BR /><BR /><SPAN>During startup, it looks like the context is applying a bunch of DB patches and dies when it gets to this one:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />10:01:53,089 User:System INFO&nbsp; [patch.impl.ResetWCMToGroupBasedPermissionsPatch] Processed 18 WCM sandbox stores: 3 secs<BR />10:01:53,476 User:System INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;Applying patch 'patch.moveWCMToGroupBasedPermissionsPatch' (A placeholder patch; usually marks a superceded patch.).<BR />10:01:53,479 User:System INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;Applying patch 'patch.wcmPostPermissionSnapshotPatch3' (Snapshot stores (after fixing ACLs so they are only set on the staging area store).).<BR />10:01:53,482 User:System ERROR [admin.patch.PatchExecuter] 09290001 com.ibatis.sqlmap.client.SqlMapException: There is no statement named select.AVMNodeEntitiesCountWhereNewInStore in this SqlMap.<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any suggestions about what to do now?</SPAN></BODY></HTML> Thu, 29 Oct 2009 15:07:31 GMT tvaughan77 2009-10-29T15:07:31Z 'Failed to apply patch' -- what to do now? https://connect.hyland.com/t5/alfresco-archive/failed-to-apply-patch-what-to-do-now/m-p/226611#M179741 Hi,I was following the backup &amp; restore procedures http://wiki.alfresco.com/wiki/Backup_and_Restore to try to get a new alfresco 3.2r installation to "come up with" the data from my old alfresco labs3d installation.&nbsp; I had a tarball of the alf_data and a mysqldump of the database, so I: * shut d Thu, 29 Oct 2009 15:07:31 GMT https://connect.hyland.com/t5/alfresco-archive/failed-to-apply-patch-what-to-do-now/m-p/226611#M179741 tvaughan77 2009-10-29T15:07:31Z Re: 'Failed to apply patch' -- what to do now? https://connect.hyland.com/t5/alfresco-archive/failed-to-apply-patch-what-to-do-now/m-p/226612#M179742 <HTML><HEAD></HEAD><BODY><SPAN>This looks like the same problem I'm having: </SPAN><A href="http://forums.alfresco.com/en/viewtopic.php?f=8&amp;t=22695" rel="nofollow noopener noreferrer">http://forums.alfresco.com/en/viewtopic.php?f=8&amp;t=22695</A><SPAN> but I haven't found a solution yet. Please post if you managed to upgrade.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Thu, 05 Nov 2009 19:34:07 GMT https://connect.hyland.com/t5/alfresco-archive/failed-to-apply-patch-what-to-do-now/m-p/226612#M179742 konsultex 2009-11-05T19:34:07Z