Classification Tree Gets Corrupt

[teamkrusty]

I have had a couple instances of alfresco get corrupted category trees.  The error I get from the web client is:  System Exception: More than one root node? and from the alfresco web client services i get this:  SimpleDeserializer encountered a child element, which is NOT expected, in something it was trying to deserialize.
The only fix I have found is to clear out my database and all my data, but this is not an ideal solution.

[derek]

Hi,

As you probably know, the link between the metadata (database), content store and indexes is maintained in a transactional manner.  It is perfectly acceptable for the system to check the database for the existence of a store, and if not present, to go ahead and create it in both the database and the indexes.

If, however, the database was cleaned out at some stage, but the indexes were left in place, then the system will create a second root node in the index.  Most probably, you cleaned the database out during some testing but left the index files lying around.

Regards