Bug 870424

Summary:	Clean Tasks from DBMS when a Process ends
Product:	[JBoss] JBoss Enterprise BRMS Platform 5	Reporter:	Martin Weiler <mweiler>
Component:	jBPM 5	Assignee:	Kris Verlaenen <kverlaen>
Status:	VERIFIED ---	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	BRMS 5.3.0.GA
Target Milestone:	CR1
Target Release:	BRMS 5.3.1 GA
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	If a process ends when persistence is enabled, the process is removed from the DBMS ProcessInstanceInfo table. However, the task table and the data related to the process are not deleted from the DBMS, causing an unnecessary growth of DBMS data. This has been resolved with the implementation of a TaskCleanUpProcessEventListener that cleans up tasks when the process instance related to them ends.	Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Martin Weiler 2012-10-26 12:55:59 UTC

Description of problem:
Platform issue for https://issues.jboss.org/browse/JBPM-3543, to ensure this makes it into the platform, and to verify that no orphaned records remain in the database after the task has been ended.

With persistence enabled,when a process ends, it is removed from DBMS (ProcessInstanceInfo table)
However the tasks (Task table) and their data (Content table,PeopleAssignments* table,I18NText) related to the process are not deleted from DBMS causing an unnecessary growth of DBMS data.

Comment 1 Kris Verlaenen 2012-10-31 13:44:01 UTC

We actually have an implementation in the community that cleans up tasks when the process instance related to it ends:
https://github.com/droolsjbpm/jbpm/blob/master/jbpm-human-task/jbpm-human-task-core/src/main/java/org/jbpm/task/admin/TaskCleanUpProcessEventListener.java

I don't think this is available in the product branch (5.2.x) however, but we can cherry-pick this.

Comment 2 Rajesh Rajasekaran 2012-10-31 15:39:37 UTC

This issue was agreed as a blocker, and has pm_ack. If we can commit to fixing this in the product branch, I will set the release flag for 5.3.1. Kris, can you comment?

Comment 3 Mauricio Salatino 2012-11-02 12:47:36 UTC

This is already in 5.2.x

Class:
https://github.com/droolsjbpm/jbpm/blob/5.2.x/jbpm-human-task/src/main/java/org/jbpm/task/admin/TaskCleanUpProcessEventListener.java
Test:
https://github.com/droolsjbpm/jbpm/blob/5.2.x/jbpm-test/src/test/java/org/jbpm/tasks/admin/AdminAPIsWithListenerTest.java

Comment 4 Douglas Hoffman 2012-11-09 04:00:47 UTC

Complied information for Release Note purposes. Thanks for updates.

- Doug

Comment 5 Marek Winkler 2012-11-14 16:37:56 UTC

The data from Content table are not cleared after the process finishes. Other tables seem to be cleared properly.

I have added more verifications into the test case: https://github.com/droolsjbpm/jbpm/pull/144

Comment 6 Mauricio Salatino 2012-11-15 11:24:49 UTC

Merged in 5.2.x and solved.

Comment 7 JBoss JIRA Server 2012-11-15 11:57:53 UTC

Mauricio Salatino <salaboy> updated the status of jira JBPM-3543 to Closed

Comment 8 JBoss JIRA Server 2012-11-15 11:57:53 UTC

Mauricio Salatino <salaboy> made a comment on jira JBPM-3543

- fixed in master and in 5.2.x

Comment 9 Marek Winkler 2012-12-03 15:01:08 UTC

Verified on 5.3.1.BRMS CR1.

Comment 13 PnT Account Manager 2017-12-07 23:34:02 UTC

Employee 'msalatin' has left the company.