topic Duplicate child name not allowed error in editing site memberships in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/duplicate-child-name-not-allowed-error-in-editing-site/m-p/305539#M258669 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN><BR /><BR /><SPAN>&lt;ol&gt;</SPAN><BR /><SPAN>&lt;li&gt;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. &lt;/li&gt;</SPAN><BR /><SPAN>&lt;li&gt;If I remove a site member from the site in one instance, the second instance is NOT reflecting this either.&lt;/li&gt;</SPAN><BR /><SPAN>&lt;li&gt;If I invite a site member to a site in one instance, the second instance DOES show the pending invite as well. &lt;/li&gt;</SPAN><BR /><SPAN>&lt;/ol&gt;</SPAN><BR /><BR /><SPAN>If anyone has any ideas on why this may be occurring, your input will be much appreciated. Thanks!</SPAN><BR /><BR /><SPAN>~ Prachi</SPAN><BR /><BR /><BR /><SPAN>&lt;blockquote&gt;</SPAN><BR /><SPAN>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</SPAN><BR /><SPAN> 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</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1126)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>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</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:204)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: org.alfresco.service.cmr.repository.DuplicateChildNodeNameException: Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$5.execute(AbstractNodeDAOImpl.java:3098)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$5.execute(AbstractNodeDAOImpl.java:3068)</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: org.springframework.dao.DuplicateKeyException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'</SPAN><BR /><SPAN>### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'</SPAN><BR /><SPAN>; 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'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)</SPAN><BR /><BR /><SPAN>&lt;/blockquote&gt;</SPAN><BR /></BODY></HTML> Fri, 02 Oct 2015 23:09:40 GMT prachi379 2015-10-02T23:09:40Z Duplicate child name not allowed error in editing site memberships https://connect.hyland.com/t5/alfresco-archive/duplicate-child-name-not-allowed-error-in-editing-site/m-p/305539#M258669 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. Fri, 02 Oct 2015 23:09:40 GMT https://connect.hyland.com/t5/alfresco-archive/duplicate-child-name-not-allowed-error-in-editing-site/m-p/305539#M258669 prachi379 2015-10-02T23:09:40Z Re: Duplicate child name not allowed error in editing site memberships https://connect.hyland.com/t5/alfresco-archive/duplicate-child-name-not-allowed-error-in-editing-site/m-p/305540#M258670 <HTML><HEAD></HEAD><BODY><P>Alfresco community doesn't support clustering</P></BODY></HTML> Thu, 03 Nov 2016 12:32:03 GMT https://connect.hyland.com/t5/alfresco-archive/duplicate-child-name-not-allowed-error-in-editing-site/m-p/305540#M258670 mcasanket 2016-11-03T12:32:03Z