Hi Guys
I 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:\alfresco\tomcat\temp\Alfresco\ImageMagickContentTransformer_init_source_18824.gif" "C:\alfresco\tomcat\temp\Alfresco\ImageMagickContentTransformer_init_target_18825.png"
15:47:17,550 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
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`))
15:47:17,690 ERROR [org.alfresco.repo.admin.patch.PatchExecuter]
=== Failed to apply patch ===
ID: patch.updateGuestPermission
RESULT:
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`))
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`))
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.Mysql…
=====================================
15:47:17,706 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Not all patches could be applied
at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:99)
When accessing the site you get:
type Status report
message /alfresco/
description The requested resource (/alfresco/) is not available.
Any help would be appreciated.
Thanks in advance.
