topic Need to purge data of activiti execution in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163611#M117404 <HTML><HEAD></HEAD><BODY><SPAN>I am new to activiti BPM. We have Activiti implemented in our project and I am seeing following tables are growing in the activiti.</SPAN><BR /><SPAN>ACT_HI_ACTINST 21,253,589</SPAN><BR /><SPAN>ACT_HI_DETAIL 18,867,706</SPAN><BR /><SPAN>ACT_HI_VARINST 18,867,705</SPAN><BR /><SPAN>ACT_HI_PROCINST 1,946,655</SPAN><BR /><SPAN>ACT_RU_VARIABLE 502,627</SPAN><BR /><SPAN>ACT_RU_EXECUTION 112,370</SPAN><BR /><SPAN>ACT_RU_IDENTITYLINK 56,307</SPAN><BR /><SPAN>I am of the understanding that after the workflow is finished, the variables associated with the workflow are deleted. But I still see half a million records in the my environment (ACT_RU_VARIABLE 502,627)</SPAN><BR /><SPAN>Similarly there are other tables which either needs to be purged or archived or both. </SPAN><BR /><SPAN>I wanted to know the best strategy to implement the purging in activiti. </SPAN><BR /><SPAN>Is there any script which comes with activiti which purges data?</SPAN><BR /></BODY></HTML> Tue, 20 Aug 2013 14:02:48 GMT sandeepkhatri01 2013-08-20T14:02:48Z Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163611#M117404 I am new to activiti BPM. We have Activiti implemented in our project and I am seeing following tables are growing in the activiti.ACT_HI_ACTINST 21,253,589ACT_HI_DETAIL 18,867,706ACT_HI_VARINST 18,867,705ACT_HI_PROCINST 1,946,655ACT_RU_VARIABLE 502,627ACT_RU_EXECUTION 112,370ACT_RU_IDENTITYLINK 56, Tue, 20 Aug 2013 14:02:48 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163611#M117404 sandeepkhatri01 2013-08-20T14:02:48Z Re: Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163612#M117405 <HTML><HEAD></HEAD><BODY><SPAN>All ACT_HI tables are history tables and will grow over time if you use a high history level. If you don't want any or less history information you can configure this in the history level. The ACT_RU tables are only for running instances, so they shouldn't grow (only if you start more instances than before).</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 21 Aug 2013 06:49:06 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163612#M117405 trademak 2013-08-21T06:49:06Z Re: Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163613#M117406 <HTML><HEAD></HEAD><BODY><SPAN>I figured out the cause why I was seeing data growth in ACT_RU tables. Whenever some runtime exception comes like NullPointerException the process variables remain in ACT_RU table and when it completes normally it clears off from there. </SPAN><BR /><SPAN>I tried explicitly catching the exception and closed the execution by calling- ((ActivityExecution) execution).end(); but it is also not working.</SPAN><BR /><BR /><SPAN>Any pointer on this behaviour will be really helpful. </SPAN></BODY></HTML> Sat, 24 Aug 2013 15:19:06 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163613#M117406 sandeepkhatri01 2013-08-24T15:19:06Z Re: Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163614#M117407 <HTML><HEAD></HEAD><BODY><SPAN>I was reading through the activit API and figured out the root cause. I am creating process variables at the process start up time and then executing service task asynchronusly. I am getting the runtime exception in service task which shall be running in transaction 2. (see the link below)</SPAN><BR /><SPAN>So, activiti process varibales were not rolled back.</SPAN><BR /><BR /><SPAN>Just wondering what is best stratgey to rollback process variables in this situation ?</SPAN><BR /><BR /><A href="http://www.activiti.org/userguide/index.html#bpmnConcurrencyAndTransactions" rel="nofollow noopener noreferrer">http://www.activiti.org/userguide/index.html#bpmnConcurrencyAndTransactions</A></BODY></HTML> Sat, 24 Aug 2013 16:53:28 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163614#M117407 sandeepkhatri01 2013-08-24T16:53:28Z Re: Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163615#M117408 <HTML><HEAD></HEAD><BODY><SPAN>That is correct behaviour: the engine brings you back the latest stable state. Why would you want this different?</SPAN></BODY></HTML> Tue, 03 Sep 2013 09:46:10 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163615#M117408 jbarrez 2013-09-03T09:46:10Z Re: Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163616#M117409 <HTML><HEAD></HEAD><BODY><SPAN>I have a requirement to delete all the leftover records from Runtime tables. The records remains in RU tables in cases where I am getting the runtime exception in service task which is running asynchronously.</SPAN></BODY></HTML> Fri, 06 Sep 2013 14:53:44 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163616#M117409 sandeepkhatri01 2013-09-06T14:53:44Z Re: Need to purge data of activiti execution https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163617#M117410 <HTML><HEAD></HEAD><BODY><SPAN>About what data are we talking about? Activiti normally rolls back all data, also in the RU tables, when it encounters an exception</SPAN></BODY></HTML> Thu, 12 Sep 2013 11:45:07 GMT https://connect.hyland.com/t5/alfresco-archive/need-to-purge-data-of-activiti-execution/m-p/163617#M117410 jbarrez 2013-09-12T11:45:07Z