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

 

Thomas

 

From: rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@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@gmail.com>

and the hibernate hql query

select 

     new org.drools.task.query.TaskSummary(

     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@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@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@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@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@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@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@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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

 

 

 


_______________________________________________
rules-users mailing list
rules-users@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@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@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