AnsweredAssumed Answered

Duplicate child name not allowed error in editing site memberships

Question asked by prachi379 on Oct 3, 2015
Latest reply on Nov 3, 2016 by mcasanket
We have two servers running alfresco community 5.0.a. Both point to the same MYSQL database and file repository and a load balancer is being used to distribute network traffic between these two servers. This configuration has been working out well for us until today when we stumbled onto this issue.

<ol>
<li>If I change the role of a user from Consumer to Contributor (as an example) for a site in one instance, the second instance is NOT reflecting this change. Below is an error from the logs. </li>
<li>If I remove a site member from the site in one instance, the second instance is NOT reflecting this either.</li>
<li>If I invite a site member to a site in one instance, the second instance DOES show the pending invite as well. </li>
</ol>

If anyone has any ideas on why this may be occurring, your input will be much appreciated. Thanks!

~ Prachi


<blockquote>
ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-21] Exception from executeScript - redirecting to status template error: 09020063 Wrapped Exception (with status template): 09026336 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/site/membership/membership.put.json.js': Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
org.springframework.extensions.webscripts.WebScriptException: 09020063 Wrapped Exception (with status template): 09026336 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/site/membership/membership.put.json.js': Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
   at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1126)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
   at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)

Caused by: org.alfresco.scripts.ScriptException: 09026336 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/site/membership/membership.put.json.js': Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:204)
   at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)

Caused by: org.alfresco.service.cmr.repository.DuplicateChildNodeNameException: Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$5.execute(AbstractNodeDAOImpl.java:3098)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$5.execute(AbstractNodeDAOImpl.java:3068)

Caused by: org.springframework.dao.DuplicateKeyException:
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'
### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'
; SQL []; Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)

</blockquote>

Outcomes