nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't find process history

navitect

Hi,

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?

Find more posts tagged with

Alfresco Process Services

Accepted answers

navitect

I eventually solved this. There was an error in my SQL statement, which was completing successfully despite the missing " ' ", with 0 rows!

All comments

pault

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 ?

navitect

Thanks for the hint.

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.

pault

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.

navitect

I believe so, the process completes to the end. There's a couple of script tasks that definitely complete as they display an output.

I thought it would be straightforward to pull off a full audit trail of a process. Seems this may not be the case.