topic Re: API for getting the start_time of any workflow instance. in Alfresco Archive

API for getting the start_time of any workflow instance.

hamepal — Wed, 10 Aug 2011 21:26:48 GMT

Hi All, I have a use-case where we need to monitor the workflow instance execution time. If any instance is taking more than a specified time we have to red-flag that instance. In order to do this we need to get the running instance start time. we tried to look into ACT_HI_PROCINST. This table ha

Re: API for getting the start_time of any workflow instance.

jbarrez — Thu, 11 Aug 2011 09:49:01 GMT

As you mention yourself, the time info is only saved at wait states. Writing your own operation around the start, saving the timestamps is the only workaround I can think of if you dont want wait states.

But then again, doesnt your process contain any wait states? It seems very unhealthy to me to keep your database transactions open for so long.

Re: API for getting the start_time of any workflow instance.

hamepal — Thu, 11 Aug 2011 15:45:15 GMT

We are not keeping the session for a long time. we are writing a demon which gets up and check the process execution time and my workflow wouldn't have any wait task.
well currently we are storing the process start time in different table.

@jbarrez Thanks for your response