Bug 1034608

Summary: A process instance cannot be aborted due to an SQLException
Product: [Retired] JBoss BPMS Platform 6 Reporter: Ivo Bek <ibek>
Component: Business CentralAssignee: Mauricio Salatino <msalatin>
Status: CLOSED CURRENTRELEASE QA Contact: Ivo Bek <ibek>
Severity: medium Docs Contact:
Priority: high    
Version: 6.0.0CC: kverlaen, mbaluch
Target Milestone: ER1   
Target Release: 6.0.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 20:03:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
server log none

Description Ivo Bek 2013-11-26 08:26:04 UTC
Description of problem:

When I start any process which contains a human task to be stopped at some point, I'm not able to abort the process instance in Business central. It's still present there without any error. I'll attach the server log with SQLException escaped proxy: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@41693adb

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. Start a process containing a human task
2. Abort the process instance in Business central
3. See the server log

Actual results:


Expected results:


Additional info:

Comment 1 Ivo Bek 2013-11-26 08:27:27 UTC
Created attachment 829096 [details]
server log

Comment 2 Ivo Bek 2013-11-26 09:01:24 UTC
After I changed the user, to not use admin, it's possible to abort it, so the problem is just for the admin.

Comment 3 Mauricio Salatino 2013-11-26 09:07:24 UTC
Hi Ivo,
Again, are you sure that you are not using the admin user for doing all of this? 
Also make sure that the task is not assigned to the admin user. Can you please confirm me that? 
Also please attach the process that you were using to test so I can try to reproduce the problem

Comment 4 Mauricio Salatino 2013-11-26 09:07:54 UTC
Ok, so I'm marking this issue as modified based on Ivo's confirmation.

Comment 5 Kris Verlaenen 2013-12-09 11:51:55 UTC
@Mauricio, this should not be set to modified unless it is fixed.  If the issue only occurs when using the admin user, this makes it less severe but it is an issue nonetheless.

Comment 6 Mauricio Salatino 2013-12-09 21:31:52 UTC
@Kris, completely agree, we should create a different issue then right? If not we will end up with tons of issues related with the use of the admin user, which will be solved all at once when we review the core cause of the issue.

Comment 7 Kris Verlaenen 2013-12-09 23:23:19 UTC
Not really, if they happen to be caused by the same underlying issue, it will be possible to close several at the same time.  But even then we would still have to verify each case.  Feel free to link issues if you believe that would be useful.

Comment 8 Mauricio Salatino 2014-02-03 21:01:05 UTC
This is already working in 6.0.x. Can you please try to verify that is already working with the latest build?

Comment 9 Mauricio Salatino 2014-02-03 22:41:15 UTC
Couldn't reproduce this after several retries. Please confirm that this is already working.

Comment 10 Ivo Bek 2014-02-04 08:47:51 UTC
@Mauricio, I am still able to reproduce the issue in BPMS 6.0.0.CR2. Did you use a user named "admin" with the role "admin"? This is the problem we talked about in this bug.

Comment 11 Mauricio Salatino 2014-02-04 13:35:14 UTC
Hi Ivo, yes I've double checked with the admin user with the admin role in the 6.0.x branch with the latest source code and I couldn't reproduce it anymore. Are you testing with the latest build? From which day?

Comment 12 Ivo Bek 2014-02-04 14:12:19 UTC
I test it with the product only (BPMS 6.0.0.CR2), not with any community release. It is possible it is currently working in 6.0.x branch. In the similar BZs (https://bugzilla.redhat.com/show_bug.cgi?id=1034242 and https://bugzilla.redhat.com/show_bug.cgi?id=1034258) you set them modified and changed the source code, so it probably fixed also this issue.

Comment 13 Lukáš Petrovický 2014-02-07 16:19:56 UTC
This no longer has a target release of 6.0.0.

Comment 14 Ivo Bek 2014-02-20 12:13:21 UTC
Verified in BPMS 6.0.1.ER1

Comment 15 Ivo Bek 2014-03-18 12:22:14 UTC
Test that a user is notified about using a username which is equal to a group (e.g. admin/admin).