AnsweredAssumed Answered

Upgrade problem from 1.2RC1 to 1.2 Release

Question asked by ssalvini on Mar 13, 2006
Latest reply on Mar 16, 2006 by derek
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.

Outcomes