topic Re: Cannot create new category in Alfresco Archive

Cannot create new category

tanoto — Tue, 08 Nov 2005 02:30:19 GMT

I experienced the following error when I tried to create a new category in the Administration Console under Category Management.The error readslease correct the errors below then click New Category.* A system error happened during the operation: More than one root node? 0Has anyone experienced sim

Re: Cannot create new category

andy — Tue, 08 Nov 2005 08:26:10 GMT

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

Re: Cannot create new category

steve — Tue, 08 Nov 2005 10:18:25 GMT

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

Re: Cannot create new category

tanoto — Wed, 09 Nov 2005 15:57:53 GMT

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

Re: Cannot create new category

steve — Thu, 10 Nov 2005 10:18:55 GMT

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