What values are stored in SRC_STEP_ACTION_RESULT_ID column in bpm_run_processes table?
In front end, I see a process has 10 instances in running state but in database it has over 150 instances showing with BPM_PIS_RUNNING state.
The only difference I could see was that the instances which appear in Clarity front end have '-1' in SRC_STEP_ACTION_RESULT_ID. Other rows in DB have values like 37871791 in SRC_STEP_ACTION_RESULT_ID.
the field indicates that it is a subprocess of another process.
SELECT brs.process_instance_id , brp.id subprocess_instance_idFROM bpm_run_processes brp INNER JOIN bpm_run_step_action_results brsar ON brp.src_step_action_result_id = brsar.id INNER JOIN bpm_run_steps brs ON brsar.step_instance_id = brs.id