I'm trying to build an SQL query to pull out the audit trail of my processes, both during and after completion. I can only find the process instance data (ACT_HI_PROCINST) in the history tables but not the history of tasks (ACT_HI_TASKINST) and execution (ACT_HI_ACTINST). I can see the details in the database from the demo processes but not for mine. I've configured history to audit and that makes no difference. Any ideas?
Have you tried using the API to create queries on the executing and historic processes, to see what the engine thinks is going on.
I have a vague recollection of hitting a similar problem some years ago with V5, where I was doing something that was delaying the transactions from committing - and the API queries allowed me to see where my problem was. What version are you on ?
I can certainly see more detail via the API. However, I'm only seeing user tasks though via the task history? Also, when I go back and look in the db after the process has completed there is still nothing for that process instance. I would've expect the commit to have occurred by then.
One thought. If a transaction roll back was occuring of course data would not be committed. Are you sure your tasks are sucessfully completing ?
I just had an issue with a process that wasn't doing what I expected. It was using a java service task with my code in it, which I suspected was causing the issue. When I put trace statements at the start and end of the process I saw it wasn't completing and a transaction timeout & roll back looked to be occuring.