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

Swindells, Thomas TSwindells at nds.com
Fri Apr 23 04:44:12 EDT 2010 

Probably not relevant but the standard language code for the UK is en-GB not en-UK,

Thomas

From: rules-users-bounces at lists.jboss.org [mailto:rules-users-bounces at lists.jboss.org] On Behalf Of Mauricio Salatino
Sent: 22 April 2010 17:22
To: Rules Users List
Subject: Re: [rules-users] Drools Flow: Another problem with Human Task

client.getTasksAssignedAsPotentialOwner("Joe", "en-UK", summaryHandler);
This method used the "en-UK" for i18n reasons.. you need to set the field content (and I'm sure right now, because that I don't have the source code here) and the field comment to "en-UK".
2010/4/22 rudolf michael <roudolf at gmail.com<mailto:roudolf at gmail.com>>
and the hibernate hql query
select
     new org.drools.task.query.TaskSummary(
     t.id<http://t.id>,
     names.text,
     subject.text,
     descriptions.text,
     t.taskData.status,
     t.priority,
     t.taskData.skipable,
     t.taskData.actualOwner,
     t.taskData.createdBy,
     t.taskData.createdOn,
     t.taskData.activationTime,
     t.taskData.expirationTime)
from
    Task t
    left join t.taskData.createdBy
    left join t.taskData.actualOwner
    left join t.subjects as subject,
    I18NText names,
    I18NText descriptions,
    OrganizationalEntity potentialOwners
where
    potentialOwners.id = :userId and
    potentialOwners in elements ( t.peopleAssignments.potentialOwners  )  and

    names.language = :language and
    names in elements( t.names) and

    subject.language = :language and

    descriptions.language = :language and
    descriptions in elements( t.descriptions) and

    t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and

    t.taskData.expirationTime is null

On Thu, Apr 22, 2010 at 5:33 PM, rudolf michael <roudolf at gmail.com<mailto:roudolf at gmail.com>> wrote:
and this is how i am listing the tasks.
try {
                                              MinaTaskClient client = new MinaTaskClient("client 1", new TaskClientHandler(SystemEventListenerFactory.getSystemEventListener()));
                                              NioSocketConnector connector = new NioSocketConnector();
                                              SocketAddress address = new InetSocketAddress("127.0.0.1",9123);
                                              client.connect(connector, address);
                                              BlockingTaskSummaryResponseHandler summaryHandler = new BlockingTaskSummaryResponseHandler();
                                              client.getTasksAssignedAsPotentialOwner("Joe", "en-UK", summaryHandler);
                                              List<TaskSummary> arg0 = summaryHandler.getResults();
                                              System.out.println("Joe's task list size is "+arg0.size());
                                              for(int i=0; i < arg0.size(); i++){
                                                          System.out.println("Task Listed for Administrator "+arg0.get(i).getId()+", name="+arg0.get(i).getName()+", status="+arg0.get(i).getStatus());
                                              }
                                  }catch(Exception ex){

                                  }

are you sure that you're connecting to the same TaskService that the drools flow engine is connected to?

On Thu, Apr 22, 2010 at 5:29 PM, rudolf michael <roudolf at gmail.com<mailto:roudolf at gmail.com>> wrote:
well i had your problem when i started doing some human task processing then after i have set the Comment for the tasks, the task list worked fine for me.
Find below my Test case logs:

Hibernate: update ProcessInstanceInfo set externalVariables=?, lastModificationDate=?, lastReadDate=?, processId=?, processInstanceByteArray=?, startDate=?, state=?, OPTLOCK=? where processInstanceId=? and OPTLOCK=?
Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, skipable, status, workItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update WorkItemInfo set creationDate=?, name=?, processInstanceId=?, state=?, OPTLOCK=?, workItemByteArray=? where workItemId=? and OPTLOCK=?
Hibernate: insert into I18NText (language, text) values (?, ?)
Hibernate: update SessionInfo set dirty=?, lastModificationDate=?, rulesByteArray=?, startDate=? where id=?
Hibernate: insert into I18NText (language, text) values (?, ?)
Hibernate: insert into I18NText (language, text) values (?, ?)
Hibernate: update I18NText set Task_Descriptions_Id=? where id=?
Hibernate: update I18NText set Task_Names_Id=? where id=?
Hibernate: insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id) values (?, ?)
Hibernate: insert into PeopleAssignments_PotentialOwners (task_id, entity_id) values (?, ?)
Hibernate: update I18NText set Task_Subjects_Id=? where id=?
INFO: RECEIVED: HeapBuffer[pos=0 lim=199 cap=2048: 00 00 00 C3 AC ED 00 05 73 72 01 00 1F 6F 72 67...]
[2010:04:112 17:04:846:debug] Message receieved on server : QueryTasksAssignedAsPotentialOwner
[2010:04:112 17:04:846:debug] Arguments : [Joe, en-UK]
Task Claimed for Joe, Task Name=1
Apr 22, 2010 5:23:13 PM org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=216 cap=256: 00 00 00 D4 AC ED 00 05 73 72 01 00 1F 6F 72 67...]
Apr 22, 2010 5:23:13 PM org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]
[2010:04:112 17:04:886:debug] Message receieved on client : AddTaskResponse
[2010:04:112 17:04:887:debug] Arguments : [1]
Hibernate: 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 Task task0_ left outer join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id, I18NText i18ntext4_, I18NText i18ntext5_, OrganizationalEntity organizati6_ where organizati6_.id=? and (organizati6_.id in (select potentialo9_.entity_id from PeopleAssignments_PotentialOwners potentialo9_ where task0_.id=potentialo9_.task_id)) and i18ntext4_.language=? and (i18ntext4_.id in (select names10_.id from I18NText names10_ where task0_.id=names10_.Task_Names_Id)) and subjects3_.language=? and i18ntext5_.language=? and (i18ntext5_.id in (select descriptio11_.id from I18NText descriptio11_ where task0_.id=descriptio11_.Task_Descriptions_Id)) and (task0_.status in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) and (task0_.expirationTime is null)
Apr 22, 2010 5:23:13 PM org.apache.mina.filter.logging.LogLevel$4 log
INFO: RECEIVED: HeapBuffer[pos=0 lim=1036 cap=2048: 00 00 01 57 AC ED 00 05 73 72 01 00 1F 6F 72 67...]
Hibernate: select user0_.id as id64_0_ from OrganizationalEntity user0_ where user0_.id=? and user0_.DTYPE='User'
[2010:04:112 17:04:896:debug] Message receieved on server : RegisterForEventRequest
[2010:04:112 17:04:896:debug] Arguments : [org.drools.task.event.TaskEventKey at c6e7d8b, true, org.drools.process.workitem.wsht.WSHumanTaskHandler]
[2010:04:112 17:04:898:debug] Message receieved on server : RegisterForEventRequest
[2010:04:112 17:04:898:debug] Arguments : [org.drools.task.event.TaskEventKey at 28075cfe, true, org.drools.process.workitem.wsht.WSHumanTaskHandler]
[2010:04:112 17:04:898:debug] Message receieved on server : RegisterForEventRequest
[2010:04:112 17:04:898:debug] Arguments : [org.drools.task.event.TaskEventKey at 28f7c114, true, org.drools.process.workitem.wsht.WSHumanTaskHandler]
[2010:04:112 17:04:901:debug] Message receieved on client : QueryTaskSummaryResponse
[2010:04:112 17:04:901:debug] Arguments : [[org.drools.task.query.TaskSummary at a467e05f]]
Joe's task list size is 1
Task Listed for Administrator 1, name=User submits request, status=Reserved

On Thu, Apr 22, 2010 at 4:16 PM, HMandic <trbuhom at net.hr<mailto:trbuhom at net.hr>> wrote:

Still no resolution...

I was reading through gazillion rows of log output (I've put
log4j.logger.org.hibernate=debug and
log4j.logger.org.hibernate.hql.ast.AST=debug in log4j.properties) for the
last few days, and still can't figure it out.
It has nothing to do with my human task item (I populated all the fields).
The problem remains that hibernate generates the wrong SQL from
"TasksAssignedAsPotentialOwner" (named query as found in orm.xml). It
generates inner join on actualOwner which is null before somebody claims
that task, that way I'll never get the list of tasks that I need to claim.

I'm using hibernate 3.5.1FINAL and orm.xml from drools 5.1.0M1 (but it's the
same as in 5.0.1).

Could it be that I'm the only one with this problem?
--
View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Flow-Another-problem-with-Human-Task-tp724086p742826.html
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users at lists.jboss.org<mailto:rules-users at lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/rules-users




_______________________________________________
rules-users mailing list
rules-users at lists.jboss.org<mailto:rules-users at lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/rules-users



--
- http://salaboy.wordpress.com
- http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -

________________________________

**************************************************************************************
This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the postmaster at nds.com and delete it from your system as well as any copies. The content of e-mails as well as traffic data may be monitored by NDS for employment and security purposes. To protect the environment please do not print this e-mail unless necessary.

NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603 8808 40-00
**************************************************************************************

________________________________
This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the postmaster at nds.com and delete it from your system as well as any copies. The content of e-mails as well as traffic data may be monitored by NDS for employment and security purposes.
To protect the environment please do not print this e-mail unless necessary.

An NDS Group Limited company. www.nds.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100423/79808547/attachment.html

More information about the rules-users mailing list