Complete Repository Export Error

[bsawler]

Hi,

I am trying to export the complete repository and when I do so I get the following error below.

I went to the node browser but honestly I have no idea what I am looking at in the node browser.  I tried searching for the nodes below but it did not find it.

Any guidance would be greatly appreciated. Thanks, Bradley

Please correct the export errors below then click OK. 
Failed to execute export: org.springframework.dao.DataIntegrityViolationException: Multiple primary associations: child: workspace://SpacesStore/ad4b3abf-e4ba-11db-8636-377ef01accfd first primary assoc: ChildAssoc[ id=11543, parent=2081, child=9227, child name=ptsc-ptsc-fso5-wpr-0004.odt, child name crc=3517694374, assoc type={http://www.alfresco.org/model/content/1.0}contains, assoc name={http://www.alfresco.org/model/content/1.0}move, isPrimary=true] second primary assoc: ChildAssoc[ id=11606, parent=10907, child=9227, child name=ptsc-ptsc-fso5-wpr-0004.odt, child name crc=3517694374, assoc type={http://www.alfresco.org/model/content/1.0}contains, assoc name={http://www.alfresco.org/model/content/1.0}move, isPrimary=true] 
‍‍‍

[derek]

Hi,

The best is to delete the first association (id=11543) from the database and restart the server.  We've come across this issue and put some checks in place to help prevent it.  To ensure we haven't missing something could you describe, in some detail, your configuration(s).

Regards

[bsawler]

Hi Derek,

I am in a bit of a jam and a bit worried, cause I set up Alfresco on this major project as a mechanical engineer and have very little IT knowledge.  The project is in about 2 months and I just received the Alfresco Book and it explained that the HSQL is a light weight development database… big mistake on my part cause I installed 2.0 and it gave the HSQL option and not knowing took a stab in the dark and used it… Now I am trying to export and will endevour to get it restored with mySQL. Till then, I will have sleepless nights. 

Now with that said, How do you delete a node?

Alfresco2.0.0 Community installed on Windows 2003R2, installed as a Console Application.

[derek]

Hi,

HSQL is constantly evolving.  I'd check the HSQL website and find out how to configure it for more heavyweight purposes.  There is an alfresco.properties file to configure the alfresco database in HSQL.  You should be able to run HSQL quite safely.  It's just not our default configuration for the quick install.

If you had a support contract, our support team could help you in more detail.  For now, figure out how to execute update statements in HSQL and delete the row from the alf_child_assoc table.  Secondly, ensure that you don't have multiple asynchronous move actions defined on any spaces.

Regards

[bsawler]

Thanks for the info.  That is good news, I will check and see what I can do.

Surprising, with 60 users in the office now, I was the one that initiated this error cause I created a "move" rule, and I am still struggling with the "inherent" check box and user security, therefore I unchecked this box and was trying to run the rule when I got this error on one of my documents.  Since it was me, I have an idea where the problem exists.

Thanks for the prompt response.

Bradley

[bsawler]

Derek,

I was daunted by your suggestion 

figure out how to execute update statements in HSQL and delete the row from the alf_child_assoc table.

so I bombed my database and recreated it with mySQL.  So far, so good.  Now if I run into the problem that I had previously, which I'm sure I will! I will use this little program (http://www.heidisql.com) as a GUI to navigate through the alfresco tables to delete any suspect nodes. 

For those out there, the program is freely downloadable, quick set and put in "localhost" and "alfresco" and "alfresco" for the username and password and select the port that you installed mySQL on (default 3306).  No nasty java based script commands etc. which is well over a non-progammers capabilities.

Regards,
Bradley