topic Re: History query returns incorrect result set in Alfresco Archive

History query returns incorrect result set

frauke — Fri, 15 Oct 2010 07:28:04 GMT

Hello everybody,the queryList<HistoricProcessInstance> his =processEngine.getHistoryService() .createHistoricProcessInstanceQuery() .processInstanceId(((ExecutionEntity) execution).getProcessInstanceId()) .list();‍‍‍‍‍‍returns a list of

Re: History query returns incorrect result set

tombaeyens — Fri, 15 Oct 2010 11:50:10 GMT

I created http://jira.codehaus.org/browse/ACT-248 for this

Re: History query returns incorrect result set

frederikherema1 — Fri, 15 Oct 2010 13:14:46 GMT

Frauke,

I double-checked the HistoricProcessInctance tests an queries, couldn't find any issues there.

Which version of activiti are you running?
Can you provide a bit more context about where you are using the code pasted above?

regards

Re: History query returns incorrect result set

frauke — Fri, 22 Oct 2010 07:00:40 GMT

Hello Frederik,

I am using Activiti 5.0 beta2 and the place were I call the history query is inside an instance of BpmnActivityBehavior.

Thank you for checking.
Best regards Frauke

Re: History query returns incorrect result set

frederikherema1 — Fri, 22 Oct 2010 07:09:29 GMT

Frauke,

Can you add your BpmnActivityBehaviour to a simple process and a testcase that shows the behaviour that you were talking about? I can't seem to reproduce it.

You can just attach it to the issue http://jira.codehaus.org/browse/ACT-248

Re: History query returns incorrect result set

frauke — Fri, 22 Oct 2010 08:36:20 GMT

Ok, I attached the test files to the jira issue.

Re: History query returns incorrect result set

frederikherema1 — Fri, 22 Oct 2010 10:48:13 GMT

This test runs green in eclipse on 5.0.rc1-SNAPSHOT on trunk.

However, you shouldn't do engine API-calls from within a BpmnJavaDelegation (or Activitybehaviour/EventListener). This could mess up transactions/command contexts, and is probably why you get unexpected results.

Re: History query returns incorrect result set

frauke — Fri, 22 Oct 2010 11:02:50 GMT

Ok, I have the following problem:
the process modifies some object and I would like to store some process information with the object when saving it in the database.
So to say, which process modified it at which time, etc. So I thought reading the process history entry before storing the object would do.

Are there any other possibilitites to solve such a problem with Activiti?

Re: History query returns incorrect result set

jbarrez — Mon, 25 Oct 2010 06:56:42 GMT

Could you clarify that a bit with a code snippet?
What exactly do you want to store in the object ?

Re: History query returns incorrect result set

frauke — Mon, 25 Oct 2010 07:52:26 GMT

Ok, I think about something like this:
But I got the point about messing up the transactional context that frederik mentioned in his post.


public class CreateObjectTask extends BpmnActivityBehavior implements ActivityBehavior {
    @Override
    public void execute(final ActivityExecution execution) throws Exception {
        MyObject o = new MyObject();
        String pid = ((ExecutionEntity) execution).getProcessInstanceId();
        HistoricProcessInstance his = processEngine.getHistoryService()
            .createHistoricProcessInstanceQuery()
            .processInstanceId(pid)
            .singleResult();
        if (his != null) {
            o.setProcessInstance(his.getProcessInstanceId());
            o.setProcessHistoryId(his.getId());
            o.setProcessStartedOn(his.getStartTime());
        }
        o.save();
    }
}