One of the steps of my process is stalled (or stalled in the middle) and I would like to track it with its process ID (PID) in the database (I've done that before but can not recall) but unsure which table that contains all the tracking for a specific PID. Can any one please adivse.
tb_process_instance - holds you process instance related data
tb_task - holds information about each task created for the processes
tb_action_instance -holds details about the actions for each process
you may also need tb_assignment and tb_queue table to join with the above tables set to fetch the desired result