topic Detected stale node entry exception in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303592#M256722 <HTML><HEAD></HEAD><BODY><SPAN>I found an error on my application when I try to create multiple nodes on Alfresco. I use Java Custom Webscripts. I want to create 20.000 new nodes with documents on a while bucle. I throw this code multiple times and all works ok. I have created 100.000 nodes. But when I thrown another time the code, an error broke my execution. I found in a log this:</SPAN><BR /><BR /><SPAN>EXCEPTION: org.springframework.dao.DataIntegrityViolationException: Detected stale node entry: NodeVersionKey [nodeId=373526, version=8] (now [NodeVersionKey [nodeId=373526, version=11]]</SPAN><BR /><BR /><SPAN>The code try to create this node multiple times, but the exception occurs again and again.</SPAN><BR /><BR /><SPAN>When occurs this exceptions? What's may be the cause that changes the version from 8 to 11?</SPAN><BR /><BR /><BR /><SPAN>I add my code for more information about the problem…</SPAN><BR /><BR /><SPAN>This is my code, when I create a node:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR /><BR />NodeRef nodeRef = null;<BR />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />try {<BR />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp; properties.put(ContentModel.PROP_NAME, name);&nbsp; <BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp; nodeRef = getNodeService().createNode(<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parent, <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ContentModel.ASSOC_CONTAINS, <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, name),<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type, <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; properties).getChildRef();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp; if (nodeRef!=null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QName CUSTOM_ASPECT_QNAME = QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, Constants.aspectTitled);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;QName,Serializable&gt; aspectValues = new HashMap&lt;QName,Serializable&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aspectValues.put(QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, Constants.titleProperty), title);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aspectValues.put(QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, Constants.descriptionProperty), description);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getNodeService().addAspect(nodeRef, CUSTOM_ASPECT_QNAME, aspectValues);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; }<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>And inside the while, I do a RetryingTransactionCallback to create each node each time. </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />boolean readonly = false;<BR />boolean requiresNew = true<BR /><BR />RetryingTransactionCallback&lt;Object&gt; txnWork = new RetryingTransactionCallback&lt;Object&gt;() {<BR />&nbsp;&nbsp; public Object execute() throws Throwable {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;Create the node…<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />};<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />TransactionService transactionService = serviceRegistry.getTransactionService();<BR />return transactionService.getRetryingTransactionHelper().doInTransaction(txnWork, readonly, requiresNew);<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Thanks a lot!</SPAN></BODY></HTML> Mon, 23 Mar 2015 08:12:09 GMT spilby 2015-03-23T08:12:09Z Detected stale node entry exception https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303592#M256722 I found an error on my application when I try to create multiple nodes on Alfresco. I use Java Custom Webscripts. I want to create 20.000 new nodes with documents on a while bucle. I throw this code multiple times and all works ok. I have created 100.000 nodes. But when I thrown another time the cod Mon, 23 Mar 2015 08:12:09 GMT https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303592#M256722 spilby 2015-03-23T08:12:09Z Re: Detected stale node entry exception https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303593#M256723 <HTML><HEAD></HEAD><BODY><SPAN>Can't see anything wrong with the code you have posted.</SPAN><BR /><BR /><SPAN>However your description of your issue(s) is/are unclear/ and you don't even specify basic details like version of alfresco used.</SPAN><BR /><BR /><SPAN>The stale node exception is associated with versioning but your code snippets above do not mention versioning.</SPAN></BODY></HTML> Mon, 23 Mar 2015 10:32:07 GMT https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303593#M256723 mrogers 2015-03-23T10:32:07Z Re: Detected stale node entry exception https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303594#M256724 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, mrogers. My alfresco jars are 4.1.6 version. </SPAN><BR /><BR /><SPAN>No, I don't use versioning on my alfresco parameters with the calls. In fact, I don't know what is versioning on a node creation.</SPAN><BR /><BR /><SPAN>Which information can I give you for better clarification of the problem?</SPAN><BR /><BR /><SPAN>Thanks again</SPAN><BR /><BR /><SPAN>Best regards</SPAN><BR /><BR /></BODY></HTML> Mon, 23 Mar 2015 11:04:59 GMT https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303594#M256724 spilby 2015-03-23T11:04:59Z Re: Detected stale node entry exception https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303595#M256725 <HTML><HEAD></HEAD><BODY><SPAN>Goog morning,</SPAN><BR /><BR /><SPAN>any suggestions? No one meets with this exception? A few information may be useful for me. </SPAN><BR /><BR /><SPAN>Thanks.</SPAN><BR /><BR /><SPAN>Best regards!</SPAN></BODY></HTML> Wed, 25 Mar 2015 08:33:44 GMT https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303595#M256725 spilby 2015-03-25T08:33:44Z Re: Detected stale node entry exception https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303596#M256726 <HTML><HEAD></HEAD><BODY><SPAN>Did you find solution of your problem? Any answers why this exception occurs?</SPAN></BODY></HTML> Fri, 24 Jul 2015 09:30:02 GMT https://connect.hyland.com/t5/alfresco-archive/detected-stale-node-entry-exception/m-p/303596#M256726 jack0077 2015-07-24T09:30:02Z