AnsweredAssumed Answered

System seems to be completely hosed after import&delete

Question asked by sacco on Sep 12, 2007
Latest reply on Jun 8, 2009 by filipemingau
In the course of trying to discover whether there was anything
further to report about:
WCM-817,
I imported the Alfresco Sample Web Project into the WCM and later
deleted it.

Subsequently I've seen numerous strange errors: in particular,
it is now impossible to Bulk Import the Sample Website again.
The errors can vary, but are frequently something like (it's almost always a
"system error happened during the operation"):

Please correct the errors below then click OK.

    * A system error happened during the operation: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.alfresco.repo.avm.PlainFileNodeImpl#1968]

I've tried removing and recreating everything up the to entire'Web Projects'
section, exporting & re-importing, etc. but to absolutely no avail.

The only remaining options I can think of are either to start doing surgey
directly on the database, or else to trash the entire repositoy and rebuild
it from scratch.  It seems a rather drastic, but I can't see any other alternatives.

Are there no tools for scanning the repository to preen out stale transactions and inconsistencies.
(There is also a piece of workflow that I can neither progress nor delete).

Outcomes