AnsweredAssumed Answered

NodeArchiveService purgeAllArchivedNodes error

Question asked by itayh on Mar 16, 2009
Hi All,

I run nodeArchiveService.purgeAllArchivedNodes(Repository.getStoreRef()); in order to permenantly delete all out archive data.
I get the next exception:
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco/alf_node_status`, CONSTRAINT `FK71C2002B7F2C8017` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`))

Any Idea how to get over that?

Outcomes