Retrieving jBPM user's Human Tasks
Hi everyone,
i'm just starting with jbpm workflows. i'm using jBPM 6.4.0.Final
I'm trying to set an example to test some flowchart i've been contructing with eclipse jBPMN2 modeler.
In that flowchart, i have a user task to which i have associated the actorId "admin" via the properties tab. the file containing my flowchart is named "BonDeCommande.bpmn"
Next to execute that, i have the following java code snippet:
// create the entity manager factory and register it in the environment
EntityManagerFactory emf = Persistence.createEntityManagerFactory("org.jbpm.persistence.jpa");
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);
// configure the environment that will be used by RuntimeManager
RuntimeEnvironment environment = RuntimeEnvironmentBuilder.Factory
.get()
.newDefaultInMemoryBuilder()
.addAsset(
ResourceFactory
.newClassPathResource("BonDeCommande.bpmn"),
ResourceType.BPMN2).entityManagerFactory(emf).get();
// Creating RuntimeManager
RuntimeManager manager = RuntimeManagerFactory.Factory.get()
.newSingletonRuntimeManager(environment);
// getting RuntimeEngine out of manager
RuntimeEngine runtime = manager.getRuntimeEngine(EmptyContext.get());
// get KieSession from runtimeEngine
KieSession ksession = runtime.getKieSession();
TaskService taskService = runtime.getTaskService();
Map<String, Object> params = new HashMap<String, Object>();
ProcessInstance processInstance = ksession.startProcess(
"com.sample.bpmn.bonDeCommande", params);
String actorId = "admin";
// this line returns no results!!! so i get an ArrayOutOfBoundException for the line after.
List<TaskSummary> list = taskService.getTasksAssignedAsPotentialOwner (actorId, "en-UK");
TaskSummary task = list.get(0); //<---- here: ArrayOutOfBoundException index:0 size: 0
taskService.claim(task.getId(), actorId);
taskService.start(task.getId(), actorId);
Map<String, Object> results = new HashMap<String, Object>();
// add results here
taskService.complete(task.getId(), actorId, results);
Knowing i have the persistence unit "org.jbpm.persistence.jpa" defined this way in my persistence.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<persistence version="2.0"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd
http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd"
xmlns="http://java.sun.com/xml/ns/persistence" xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/koosserydesk-jbpm-ds</jta-data-source>
<mapping-file>META-INF/Taskorm.xml</mapping-file>
<mapping-file>META-INF/JBPMorm.xml</mapping-file>
<mapping-file>META-INF/TaskAuditorm.xml</mapping-file>
<class>org.drools.persistence.info.SessionInfo</class>
<class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.info.WorkItemInfo</class>
<class>org.jbpm.persistence.correlation.CorrelationKeyInfo</class>
<class>org.jbpm.persistence.correlation.CorrelationPropertyInfo</class>
<class>org.jbpm.process.audit.ProcessInstanceLog</class>
<class>org.jbpm.process.audit.NodeInstanceLog</class>
<class>org.jbpm.process.audit.VariableInstanceLog</class>
<!-- manager -->
<class>org.jbpm.runtime.manager.impl.jpa.ContextMappingInfo</class>
<class>org.jbpm.services.task.impl.model.AttachmentImpl</class>
<class>org.jbpm.services.task.impl.model.ContentImpl</class>
<class>org.jbpm.services.task.impl.model.BooleanExpressionImpl</class>
<class>org.jbpm.services.task.impl.model.CommentImpl</class>
<class>org.jbpm.services.task.impl.model.DeadlineImpl</class>
<class>org.jbpm.services.task.impl.model.CommentImpl</class>
<class>org.jbpm.services.task.impl.model.DeadlineImpl</class>
<class>org.jbpm.services.task.impl.model.DelegationImpl</class>
<class>org.jbpm.services.task.impl.model.EscalationImpl</class>
<class>org.jbpm.services.task.impl.model.GroupImpl</class>
<class>org.jbpm.services.task.impl.model.I18NTextImpl</class>
<class>org.jbpm.services.task.impl.model.NotificationImpl</class>
<class>org.jbpm.services.task.impl.model.EmailNotificationImpl</class>
<class>org.jbpm.services.task.impl.model.EmailNotificationHeaderImpl</class>
<class>org.jbpm.services.task.impl.model.PeopleAssignmentsImpl</class>
<class>org.jbpm.services.task.impl.model.ReassignmentImpl</class>
<class>org.jbpm.services.task.impl.model.TaskImpl</class>
<class>org.jbpm.services.task.impl.model.TaskDataImpl</class>
<class>org.jbpm.services.task.impl.model.UserImpl</class>
<!-- Task Audit Classes -->
<class>org.jbpm.services.task.audit.impl.model.AuditTaskImpl</class>
<class>org.jbpm.services.task.audit.impl.model.TaskVariableImpl</class>
<!--BAM for task service -->
<class>org.jbpm.services.task.audit.impl.model.BAMTaskSummaryImpl</class>
<!-- Event Classes -->
<class>org.jbpm.services.task.audit.impl.model.TaskEventImpl</class>
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
<property name="hibernate.max_fetch_depth" value="5" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.transaction.jta.platform"
value="org.hibernate.service.jta.platform.internal.SunOneJtaPlatform" />
</properties>
</persistence-unit>
</persistence>
When i launch the test, i have in my database these tables getting generated:
| Attachment | | |
| | AuditTaskImpl | | |
| | BAMTaskSummary | | |
| | BooleanExpression | | |
| | Content | | |
| | ContextMappingInfo | | |
| | CorrelationKeyInfo | | |
| | CorrelationPropertyInfo | | |
| | Deadline | | |
| | Delegation_delegates | | |
| | Escalation | | |
| | EventTypes | | |
| | I18NText | | |
| | NodeInstanceLog | | |
| | Notification | | |
| | Notification_BAs | | |
| | Notification_Recipients | | |
| | Notification_email_header | | |
| | OrganizationalEntity | | |
| | PeopleAssignments_BAs | | |
| PeopleAssignments_ExclOwners |
| | PeopleAssignments_PotOwners | | |
| PeopleAssignments_Recipients |
| PeopleAssignments_Stakeholders |
| | ProcessInstanceInfo | | |
| | ProcessInstanceLog | | |
| | Reassignment | | |
| Reassignment_potentialOwners |
| | SessionInfo | | |
| | Task | | |
| | TaskEvent | | |
| | TaskVariableImpl | | |
| | VariableInstanceLog | | |
| | WorkItemInfo | | |
| | email_header | | |
| task_comment
i know that the users should be stored in OrganizationalEntity table, so listing the content gave me this:
+-------+----------------+
| DTYPE | id |
+-------+----------------+
| User | Administrator |
| Group | Administrators |
+-------+----------------+
Should this table have more records than this ???
I even put a file name userinfo.properties to my classpath containing users definitions.
I dont know what i'm mssing but i really need help!
An additionnal info: whille diving in my server logs, i see that this is the request returning no rresults:
select distinct taskimpl0_.id as col_0_0_, taskimpl0_.name as col_1_0_, taskimpl0_.description as col_2_0_, taskimpl0_.status as col_3_0_, taskimpl0_.priority as col_4_0_, taskimpl0_.actualOwner_id as col_5_0_, taskimpl0_.createdBy_id as col_6_0_, taskimpl0_.createdOn as col_7_0_, taskimpl0_.activationTime as col_8_0_, taskimpl0_.expirationTime as col_9_0_, taskimpl0_.processId as col_10_0_, taskimpl0_.processInstanceId as col_11_0_, taskimpl0_.parentId as col_12_0_, taskimpl0_.deploymentId as col_13_0_, taskimpl0_.skipable as col_14_0_ from Task taskimpl0_ inner join PeopleAssignments_PotOwners potentialo1_ on taskimpl0_.id=potentialo1_.task_id inner join OrganizationalEntity organizati2_ on potentialo1_.entity_id=organizati2_.id left outer join PeopleAssignments_ExclOwners excludedow3_ on taskimpl0_.id=excludedow3_.task_id left outer join OrganizationalEntity organizati4_ on excludedow3_.entity_id=organizati4_.id where taskimpl0_.archived=0 and (taskimpl0_.actualOwner_id=? or taskimpl0_.actualOwner_id is null) and (taskimpl0_.status in (? , ? , ?)) and (organizati2_.id=? or organizati2_.id in (?)) and ( not (exists (select organizati6_.id from PeopleAssignments_ExclOwners excludedow5_, OrganizationalEntity organizati6_ where taskimpl0_.id=excludedow5_.task_id and excludedow5_.entity_id=organizati6_.id)) or organizati4_.id<>?) order by taskimpl0_.id DESC
Really need help! thanks.