topic Upgrade problem from 1.2RC1 to 1.2 Release in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrade-problem-from-1-2rc1-to-1-2-release/m-p/10300#M3862 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guys</SPAN><BR /><BR /><SPAN>I have just updated from 1.2RC1 to 1.2 Release, the upgrade fails with the following error in the log.</SPAN><BR /><BR /><SPAN>15:47:13,831 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: imconvert "C:\alfresco\tomcat\temp\Alfresco\ImageMagickContentTransformer_init_source_18824.gif"&nbsp; "C:\alfresco\tomcat\temp\Alfresco\ImageMagickContentTransformer_init_target_18825.png"</SPAN><BR /><SPAN>15:47:17,550 INFO&nbsp; [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …</SPAN><BR /><SPAN>15:47:17,659 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot add or update a child row: a foreign key constraint fails (`alfresco/node_perm_entry`, CONSTRAINT `FKCFE31CC05A6A54C3` FOREIGN KEY (`typeUri`, `typeName`, `name`) REFERENCES `permission_ref` (`type_uri`, `type_name`, `name`))</SPAN><BR /><SPAN>15:47:17,690 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] </SPAN><BR /><SPAN>=== Failed to apply patch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; === </SPAN><BR /><SPAN>ID: patch.updateGuestPermission</SPAN><BR /><SPAN>RESULT: </SPAN><BR /><SPAN>org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute update query; SQL [update node_perm_entry set name=? where name=?]; Cannot add or update a child row: a foreign key constraint fails (`alfresco/node_perm_entry`, CONSTRAINT `FKCFE31CC05A6A54C3` FOREIGN KEY (`typeUri`, `typeName`, `name`) REFERENCES `permission_ref` (`type_uri`, `type_name`, `name`)); nested exception is java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`alfresco/node_perm_entry`, CONSTRAINT `FKCFE31CC05A6A54C3` FOREIGN KEY (`typeUri`, `typeName`, `name`) REFERENCES `permission_ref` (`type_uri`, `type_name`, `name`))</SPAN><BR /><SPAN>java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`alfresco/node_perm_entry`, CONSTRAINT `FKCFE31CC05A6A54C3` FOREIGN KEY (`typeUri`, `typeName`, `name`) REFERENCES `permission_ref` (`type_uri`, `type_name`, `name`))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Mysql…</SPAN><BR /><SPAN>=====================================</SPAN><BR /><SPAN>15:47:17,706 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Not all patches could be applied</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:99)</SPAN><BR /><BR /><SPAN>When accessing the site you get:</SPAN><BR /><BR /><SPAN>type Status report</SPAN><BR /><BR /><SPAN>message /alfresco/</SPAN><BR /><BR /><SPAN>description The requested resource (/alfresco/) is not available.</SPAN><BR /><BR /><SPAN>Any help would be appreciated.</SPAN><BR /><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Mon, 13 Mar 2006 16:08:15 GMT ssalvini 2006-03-13T16:08:15Z Upgrade problem from 1.2RC1 to 1.2 Release https://connect.hyland.com/t5/alfresco-archive/upgrade-problem-from-1-2rc1-to-1-2-release/m-p/10300#M3862 Hi GuysI have just updated from 1.2RC1 to 1.2 Release, the upgrade fails with the following error in the log.15:47:13,831 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: imconvert "C:\alf Mon, 13 Mar 2006 16:08:15 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-problem-from-1-2rc1-to-1-2-release/m-p/10300#M3862 ssalvini 2006-03-13T16:08:15Z Re: Upgrade problem from 1.2RC1 to 1.2 Release https://connect.hyland.com/t5/alfresco-archive/upgrade-problem-from-1-2rc1-to-1-2-release/m-p/10301#M3863 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Can you confirm that you have not run multiple concurrent Alfresco servers against the same database before?&nbsp; Also, are you using transactional tables?</SPAN><BR /><BR /><SPAN>What database version are you using?</SPAN></BODY></HTML> Thu, 16 Mar 2006 14:16:58 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-problem-from-1-2rc1-to-1-2-release/m-p/10301#M3863 derek 2006-03-16T14:16:58Z