Cannot create new category

[tanoto]

I experienced the following error when I tried to create a new category in the Administration Console under Category Management.

The error reads:

Please correct the errors below then click New Category.
* A system error happened during the operation: More than one root node? 0

Has anyone experienced similar problem?  Any tips on how to resolve this problem?

Thanks.

Tanoto

[andy]

Hi

This can only happen if you have your database and content/indexes out of sync.

This is most likely to be caused by:

* your config is not pointing to the correct location for indexes and content;
* cleaning out the database but not the indexes;
* cleaning out the indexes but not the database (and you do not have a version that will rebuild the indexes if they are missing).

Regards

Andy

[steve]

Hello,

This can also happen if you have deployed over the top of an old version.
The categories changed, so what might have happened is that you now have both the old set and the new set of categories in the database.
Try cleaning your database and redeploying, that should fix the issue.

Steve

[tanoto]

Hi,

Do you have any guidance on how to clean the and redeploy the database to fix the category problem?  Any best practices?  I do not wish to lose the metadata of the files that are already in the CIFS repository. 

Thanks.

Tanoto

[steve]

Hello,

You could use the export tool to export your data.
Then clean out your alfresco install - drop and recreate the database and remove the alf_data folder.
(You might want to do a seperate deployment to ensure you don't loose any data if something goes wrong - copy your existing alfresco database and tomcat dirs so you can rename them back if something goes wrong - although it shouldn't).
Once you have a fresh install, with working categories, import your previous export and you should have all your data back.

Hope this helps,

Steve