AnsweredAssumed Answered

Process Instance Error: Corresponding Steps and Objects

Question asked by paritosh.hebbal on Mar 18, 2013
Latest reply on Mar 25, 2013 by navzjoshi00
Hey guys,

There are a few process instances which are in Error mode. I need to query the steps and objects corresponding to these process instances only. I tried the following:

SELECT step_code ds,
dp.process_code
FROM niku.bpm_def_processes dp,
niku.bpm_def_process_versions pv,
niku.bpm_run_processes rp,
niku.bpm_run_steps rs,
niku.bpm_def_steps ds
WHERE
dp.id = pv.process_id
AND pv.id = rp.process_version_id
AND rp.id = rs.process_instance_id
AND rs.step_id = ds.id
AND rs.status_code = 'BPM_SIS_ERROR'
AND rp.status_code = 'BPM_PIS_ERROR'

This returns 277 rows. Note that this query returns only the steps which cause the errors. (I guess)

Can you tell me how to get the objects too?

Outcomes