Process chain kill

With one the last updates of SAP BW 7.5 I recognized the behaviour that a chain is in status yellow just because one old request was not fully progressed after e.g. an outage. The following snipped stops the yellow chain runs just by checking the status of the log entry of the chain run.

REPORT z_chainkill.

DATA: lt_chain TYPE STANDARD TABLE OF rspclogchain.

DATA lv_e_message TYPE so_text255.

PARAMETERS: pchain TYPE rspc_chain.

SELECT * FROM rspclogchain
INTO CORRESPONDING FIELDS OF TABLE lt_chain
WHERE chain_id = pchain AND analyzed = '' AND analyzed_status = 'A'.

LOOP AT lt_chain ASSIGNING FIELD-SYMBOL(<c>).

CALL FUNCTION 'RSPC_API_CHAIN_GET_STATUS'
EXPORTING
i_chain = <c>-chain_id
i_logid = <c>-log_id
IMPORTING
e_message = lv_e_message
.
WRITE: / lv_e_message.
ENDLOOP.