SAP XI/PI: Alerts for Queue Errors

[santhosh_kumarv]

Alerts can help us so much with the monitoring of the Exchange Infrastructure. Till now there are Blogs, which tells how to create alerts for Monitoring Errors, Imagine the luxury of Alerts being created for the errors in Inbound and Outbound Queues.

In most of the support projects it is always a mechanical task to check for errors in Queues (SMQ1 & SMQ2) very frequently. An Alert creation for this task will less the burden of queue monitoring and will enrich the usage of the alerts in monitoring space.

Through this Blog I would walk through with the steps to create Queue Alerts. The task here is broken into two-piece.

1. Programming with the qRFC API to obtain the Queue Information.

2. Alert Category creation and triggering Alerts from the Program.

qRFC API's :

TRFC_QOUT_OVERVIEW - This function module gives an overview of the current outbound queues that exist for various optional import parameters, for example, queue name, destination, SAP client.

TRFC_QIN_OVERVIEW - This function module gives an overview of all the inbound queues that currently exist for various optional import parameters, for example, queue name or SAP client.

Alert API:

SALERT_CREATE - This Function module is used to create alert by importing parameters like alert category, Container name and its value.

Let us now look at the steps to create queue alerts.

Step 1:

Create an Alert Category QUEUE_ERR (T-Code: ALRTCATDEF) with the following Containers.



Step 2:

Add the Message Title, Short, Long Text and you SAP logon id in Fixed Recipients list.



Stuck with Alert creation..? Refer Michal's Blog  The specified item was not found.

Step 3:

Create a report Z_QUEUE_ALERT in SE38.

Copy paste the below source code to check the queues and create Alert for queues with the Status SYSFAIL.

REPORT  Z_QUEUE_ALERT.DATA: Z_QVIEW_INB LIKE TRFCQVIEW OCCURS 1,      Z_QVIEW_OUB LIKE TRFCQVIEW OCCURS 1,      Z_QVIEW LIKE TRFCQVIEW OCCURS 1,      WA_QVIEW LIKE LINE OF Z_QVIEW_OUB,      Z_IT_CONTAINER LIKE SWCONT OCCURS 1,      WA_IT_CONTAINER LIKE LINE OF Z_IT_CONTAINER,      LCL_CAR TYPE CHAR4,      LCL_DIR TYPE CHAR10.CALL FUNCTION 'TRFC_QIN_OVERVIEW' EXPORTING   QNAME         = '*'   CLIENT        = SY-MANDT  TABLES    QVIEW         = Z_QVIEW_INB.CALL FUNCTION 'TRFC_QOUT_OVERVIEW' EXPORTING   QNAME                = '*'   DEST                 = '*'   CLIENT               = SY-MANDT  TABLES    QVIEW                = Z_QVIEW_OUB.IF NOT Z_QVIEW_INB IS INITIAL.LCL_DIR = 'INBOUND'.PERFORM CREATEALERT TABLES Z_QVIEW_INB.ENDIF.IF NOT Z_QVIEW_OUB IS INITIAL.LCL_DIR = 'OUTBOUND'.PERFORM CREATEALERT TABLES Z_QVIEW_OUB.ENDIF.FORM CREATEALERT TABLES  I_QVIEW LIKE Z_QVIEW.LOOP AT I_QVIEW INTO WA_QVIEW WHERE QSTATE EQ 'SYSFAIL'.WA_IT_CONTAINER-ELEMENT = 'ZQUEUE'.WA_IT_CONTAINER-ELEMLENGTH = '70'.WA_IT_CONTAINER-TYPE = 'C'.WA_IT_CONTAINER-VALUE = WA_QVIEW-QNAME.APPEND WA_IT_CONTAINER TO Z_IT_CONTAINER.CLEAR WA_IT_CONTAINER.WA_IT_CONTAINER-ELEMENT = 'ZQUEUE_NO'.WA_IT_CONTAINER-ELEMLENGTH = '10'.WA_IT_CONTAINER-TYPE = 'C'.WRITE WA_QVIEW-QDEEP TO LCL_CAR.WA_IT_CONTAINER-VALUE = LCL_CAR.APPEND WA_IT_CONTAINER TO Z_IT_CONTAINER.CLEAR WA_IT_CONTAINER.WA_IT_CONTAINER-ELEMENT = 'ZDIR'.WA_IT_CONTAINER-ELEMLENGTH = '10'.WA_IT_CONTAINER-TYPE = 'C'.WA_IT_CONTAINER-VALUE = LCL_DIR.APPEND WA_IT_CONTAINER TO Z_IT_CONTAINER.CLEAR WA_IT_CONTAINER.WA_IT_CONTAINER-ELEMENT = 'ZERROR'.WA_IT_CONTAINER-ELEMLENGTH = '73'.WA_IT_CONTAINER-TYPE = 'C'.WA_IT_CONTAINER-VALUE = WA_QVIEW-ERRMESS.APPEND WA_IT_CONTAINER TO Z_IT_CONTAINER.CALL FUNCTION 'SALERT_CREATE' EXPORTING   IP_CAT                       = 'QUEUE_ERR' TABLES   IT_CONTAINER                 = Z_IT_CONTAINER EXCEPTIONS   ALERT_CATEGORY_UNKNOWN       = 1   ALERT_NO_RECIPIENTS          = 2   ALERT_ERROR_UNKNOWN          = 3   OTHERS                       = 4          .IF SY-SUBRC <> 0.* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.ENDIF.CLEAR: WA_IT_CONTAINER, Z_IT_CONTAINER.ENDLOOP.ENDFORM.

Step 4:

Schedule this report using SM36 to check and trigger alert time after time.

With this above four steps you are ready to receive a Alert message in RWB Alert Inbox as below and an email to the smtp address maintained for your SAP logon id in SU01.