topic Re: Alfresco Script and long running transactions in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-script-and-long-running-transactions/m-p/279521#M232651 <HTML><HEAD></HEAD><BODY><SPAN>I suggest you look at your error log, I suspect you will find a transacion buffer error (probably says warning but my experience is that it stops doing updates once you hit the warning). If I am correct then you problem is that your javascript is trying to do all the updates in one transaction and running out of transaction buffer space. You need to split it into multiple transactions.</SPAN><BR /><BR /><SPAN>Now, I have had this problem, but never found a way to split a single javascript execution into multiple transactions. I think you can do wthis by executing actions against each record because I believe (only from what I have read) that each action runs in a discrete transaction.</SPAN><BR /><BR /><SPAN>When I encountered this issue, in the end, I wrote a PHP script and did it via CMIS because each CMIS update is executed in a single transaction.</SPAN></BODY></HTML> Mon, 09 Dec 2013 23:24:14 GMT rjohnson 2013-12-09T23:24:14Z Alfresco Script and long running transactions https://connect.hyland.com/t5/alfresco-archive/alfresco-script-and-long-running-transactions/m-p/279520#M232650 Hi all, I've tried to search for this topic with no luck (I admit I was not so sure what to look for). So here is my issue: I've to "adjust" a set of nodes (fixing some properties and move to a different path). I usually do this with a simple javascript script that uses a lucene query to get the lis Mon, 09 Dec 2013 18:29:48 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-script-and-long-running-transactions/m-p/279520#M232650 eureka 2013-12-09T18:29:48Z Re: Alfresco Script and long running transactions https://connect.hyland.com/t5/alfresco-archive/alfresco-script-and-long-running-transactions/m-p/279521#M232651 <HTML><HEAD></HEAD><BODY><SPAN>I suggest you look at your error log, I suspect you will find a transacion buffer error (probably says warning but my experience is that it stops doing updates once you hit the warning). If I am correct then you problem is that your javascript is trying to do all the updates in one transaction and running out of transaction buffer space. You need to split it into multiple transactions.</SPAN><BR /><BR /><SPAN>Now, I have had this problem, but never found a way to split a single javascript execution into multiple transactions. I think you can do wthis by executing actions against each record because I believe (only from what I have read) that each action runs in a discrete transaction.</SPAN><BR /><BR /><SPAN>When I encountered this issue, in the end, I wrote a PHP script and did it via CMIS because each CMIS update is executed in a single transaction.</SPAN></BODY></HTML> Mon, 09 Dec 2013 23:24:14 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-script-and-long-running-transactions/m-p/279521#M232651 rjohnson 2013-12-09T23:24:14Z