Collector for BW Process Chain Steps

The technical name of the Collector for BW Process Chain Steps is /DVD/MON_BW_CL_COL_ETL_PC.

This collector monitors BW process chains and their status.

Default KPIs Delivered with This Collector

The following default KPIs are delivered with this collector:

KPI name	Description	Unit	Detail table
BW_ETL_EXCEEDED_PC	BW: Number of long-running process chains	Number	Yes
BW_ETL_FAILED_PC	BW: Number of failed process chains	Number	Yes
BW_ETL_FINISHED_PC	BW: Number of successfully finished process chains	Number	Yes
BW_ETL_RUNNING_PC	BW: Number of running process chains	Number	Yes

Parameters

The following parameters are used for this collector:

Parameter name	Description
DAYS_BACK_THRESHOLD	Defines how many days to look back when monitoring process chains.

Detail Table

The collector provides two detail tables: BW: Process chain details and BW: PC steps details. The technical names of the detail tables are /DVD/MON_BW_T_PC_DETAIL and /DVD/MON_BW_T_PC_STEP_DET.

The detail table BW: Process Chain Details provides details of process chains. It contains the following fields:

Technical name	Description
CHAIN_ID	Process chain ID
LOG_ID	Log ID of a process chain run
STARTTIMESTAMP	Process chain start timestamp
ENDTIMESTAMP	Process chain end timestamp
ANALYZED_STATUS	Status of process
PC_STATUS	Process chain status
RUNTIME	Process chain runtime in seconds

The second detail table BW: PC Steps Details provides details about single steps of process chains. It contains the following fields:

Technical name	Description
LOCAL_CHAIN	Subchain ID
META_CHAIN	Process chain
LOG_ID	Log ID of a process chain run
STARTTIMESTAMP	Process chain start timestamp
ENDTIMESTAMP	Process chain end timestamp
STEP_STATUS	Process chain step status text
TYPE	Process type
STATE	Status of process
VARIANTE	Process variant (name)
INSTANCE	Process instance (value)
RUNTIME	Process chain runtime in seconds