[rules-users] Drools Flow: Another problem with Human Task

[HMandic]

Hi,

I need some help here. 

I have a simple process with one human task. That human task work item has
all the necessary fields filled (actorid, id, name, etc.). When I start that
process it gets to that human task and fills everything it needs in the
database (Postgres) through hibernate. Up until here it works fine. 
But then when I need to get a list of tasks for some particular user it
breaks because the task list is empty.

The code looks like this:

*******************************************************************************

BlockingTaskSummaryResponseHandler responseHandler = new
BlockingTaskSummaryResponseHandler();
client.getTasksAssignedAsPotentialOwner("thatUserOfMine", "en-UK",
responseHandler);
List<TaskSummary> tasks = responseHandler.getResults();
TaskSummary task = tasks.get(0);

*******************************************************************************

In that last line I get java.lang.IndexOutOfBoundsException, of course...

Now here's the problem - hibernate generates the following SQL:

*******************************************************************************
[LOG MESSAGE] Message receieved on server :
QueryTasksAssignedAsPotentialOwner
select 
	task0_.id as col_0_0_, 
	i18ntext4_.text as col_1_0_, 
	subjects3_.text as col_2_0_, 
	i18ntext5_.text as col_3_0_, 
	task0_.status as col_4_0_, 
	task0_.priority as col_5_0_, 
	task0_.skipable as col_6_0_, 
	task0_.actualOwner_id as col_7_0_, 
	task0_.createdBy_id as col_8_0_, 
	task0_.createdOn as col_9_0_, 
	task0_.activationTime as col_10_0_, 
	task0_.expirationTime as col_11_0_ 
from 
	test1.Task task0_ 
		left outer join 
			test1.OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id 
		left outer join 
			test1.OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id 
		left outer join 
			test1.I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id 
     !!!	inner join 
			test1.OrganizationalEntity user7_ on task0_.actualOwner_id=user7_.id 
		inner join 
			test1.OrganizationalEntity user8_ on task0_.createdBy_id=user8_.id 
		cross join 
			test1.I18NText i18ntext4_ 
		cross join 
			test1.I18NText i18ntext5_ 
		cross join 
			test1.OrganizationalEntity organizati6_ 
where 
	organizati6_.id = 'thatUserOfMine' 
	and (organizati6_.id in (select potentialo9_.entity_id from
test1.PeopleAssignments_PotentialOwners potentialo9_ where
task0_.id=potentialo9_.task_id)) 
	and i18ntext4_.language = 'en-UK' 
	and (i18ntext4_.id in (select names10_.id from test1.I18NText names10_
where task0_.id=names10_.Task_Names_Id)) 
	and (subjects3_.language = 'en-UK' or (select
count(subjects11_.Task_Subjects_Id) from test1.I18NText subjects11_ where
task0_.id=subjects11_.Task_Subjects_Id) = 0) 
	and (i18ntext5_.language = 'en-UK' 
	     and (i18ntext5_.id in (select descriptio12_.id from test1.I18NText
descriptio12_ where task0_.id=descriptio12_.Task_Descriptions_Id)) 
	     or (select count(descriptio13_.Task_Descriptions_Id) from
test1.I18NText descriptio13_ where
task0_.id=descriptio13_.Task_Descriptions_Id) = 0) 
	and (task0_.status in ('Created' , 'Ready' , 'Reserved' , 'InProgress' ,
'Suspended')) 
	and (task0_.expirationTime is null)
;

*******************************************************************************

You will notice the inner join with '!!!' in front of it. That's the reason
why this list is always empty, because at this stage of human task there is
no actual owner, that field is NULL. I've tried different versions of
orm.xml (from 5.0.1, 5.1.0M1 and the latest from trunk) but they all produce
the same error.

Can someone please point out what I'm doing wrong (I'm also not very good
with hibernate).



-- 
View this message in context: http://n3.nabble.com/Drools-Flow-Another-problem-with-Human-Task-tp724086p724086.html
Sent from the Drools - User mailing list archive at Nabble.com.