Bug 1034608 - A process instance cannot be aborted due to an SQLException
Summary: A process instance cannot be aborted due to an SQLException
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: Business Central
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
high
medium
Target Milestone: ER1
: 6.0.1
Assignee: Mauricio Salatino
QA Contact: Ivo Bek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-11-26 08:26 UTC by Ivo Bek
Modified: 2014-08-06 20:03 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-08-06 20:03:01 UTC
Type: Bug


Attachments (Terms of Use)
server log (32.64 KB, text/x-log)
2013-11-26 08:27 UTC, Ivo Bek
no flags Details

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).


Note You need to log in before you can comment on or make changes to this bug.