Hello,

I'm develop a functionality to track all the user history and automatic steps on process, for this task I had identified two candidate tables(find below our issues/doubts):

Audit table: NodeInstanceLog

SELECT NN.NODENAME, NN.NODETYPE, NN.LOG_DATE, NN.TYPE FROM NodeInstanceLog NN

WHERE NN.PROCESSINSTANCEID = 143 and NODETYPE in ('WorkItemNode','HumanTaskNode')

order by nodeinstanceid,NN.type;

Audit table: TaskEvent

SELECT T.PROCESSINSTANCEID,T.ID, TE.ID,T.NAME,T.STATUS TASKSTATUS, T.FAULTTYPE,TE.TYPE TASKEVENT_TYPE,TE.LOGTIME,TE.USERID

FROM TaskEvent TE,TASK T

WHERE TE.PROCESSINSTANCEID = 143

AND T.ID=TE.TASKID

ORDER BY TE.ID;

For this tables, I need to obtain the following data:

• Any can give me a suggest to complete this task?
• Also, the documentation for TaskEvent is not online, any can tell us if this is a good table to perform the query?

Also, we can’t use TaskEvent, because some time the information is incomplete. You can see below the data from these tables:

Example for TaskEvent:

Inconsistence state:

Consistence status:

NOTE: the inconsistent scenario happens because the org.jbpm.runtime.manager.impl.PerRequestRuntimeManager, local variable sometime is empty, because the WAS assign a different thread to the RuntimeManager. The scope of local variable is Thread:

public class PerRequestRuntimeManager extends AbstractRuntimeManager {

       private SessionFactory factory;

       private TaskServiceFactory taskServiceFactory;

       private static ThreadLocal<RuntimeEngine> local = new ThreadLocal();

• Any can comment if this is an real inconsistency or it is a normal behavior?

Example for NodeInstanceLog:

Thanks if advance,

Miguel Angel