CA Clarity Tuesday Tip - How to query DB for process and steps

Discussion created by Aurora_Gaimon Employee on Dec 10, 2013
Latest reply on Dec 10, 2013 by Chris_Hackett

When analyzing bg-niku.log / bg-ca.log, we can find errors related to process and steps. We just see the internal ID and not their names which makes dificult to locate process in Clarity UI.

The error "com.niku.bpm.BpmException: Cannot get step definition by step ID xxxxxxx"

You can use following query to get more details from DataBase:

select  process_id, process_name, step_id, step_name
from bpm_def_processes  bdp
 inner join bpm_def_process_versions bdpv on =  bdpv.process_id
 inner join cmn_captions_nls ccn on = ccn.pk_id
   and ccn.table_name = 'BPM_DEF_PROCESSES'
   and ccn.language_code = 'en'
 inner join bpm_def_stages bdsa on = bdsa.process_version_id
 inner join bpm_def_steps bdse on = bdse.stage_id
 inner join cmn_captions_nls bdsecap on = bdsecap.pk_id
   and bdsecap.table_name = 'BPM_DEF_STEPS'
   and bdsecap.language_code = 'en'