Skip to Content
Author's profile photo Former Member

Monitoring XI/PI queues on your iPhone — Part 1

A quick way to check the health of your SAP PI system is to see the status of its queues. If messages get stuck in queues, you either have a slow system or an error situation. Queues can be monitored in SAP with the SMQ2 transaction.

The problem with this approach is that it requires you to logon to SAP and execute SMQ2 transaction. SMQ2 doesn’t neatly summarize the status for a quick glance. I wanted a simpler graph that shows me this information, and I wanted this to be accessible from my iPhone. This article series describes the steps I took to create it.

h3. Overview 

Part 1 – Introduction to the iPhone monitor (this blog)
[Part 2 | Monitoring XI/PI queues on your iPhone — Part 2 – Retrieving Queue Information from SAP PI with Perl] – Retrieving Queue information from SAP PI with Perl.

[Part 3 | Monitoring XI/PI queues on your iPhone — Part 3 – Create charts] – Creating a web page with a bar chart using Google Charts.(*view a demo*)
[Part 4 | Monitoring XI/PI queues on your iPhone — Part 4 – iPhone webapp] – Package the website as an ITouch application

h3. Screenshots

It always helps to see what the end result would be like. So here are some screenshots from the iPhone and *view a demo* of the website.

 !http://farm5.static.flickr.com/4023/4584782826_725c1a5850_o.jpg|height=480|alt=iPhone Menu|align=top|width=320|src=http://farm5.static.flickr.com/4023/4584782826_725c1a5850_o.jpg|border=1! !http://farm5.static.flickr.com/4034/4584155039_d0c9e37b02_o.jpg|height=480|alt=Queue graph|align=top|width=320|src=http://farm5.static.flickr.com/4034/4584155039_d0c9e37b02_o.jpg|border=0!

 

h4. Tools

  • SQLite command line shell.
  • iWebKit to package the website as an iPhone application.
  • Apache Tomcat or IIS to test your website locally.
  • Amazon S3 to host the website. (You could use something else).

h4. Preparing your environment

We need a working Perl environment with all the modules. The instructions for this setup is in a seperate blog – Using Perl for SAP RFC – Part 1 – Installing PerlAlternatively see the next section on a QuickStart.

You can download the SQLite command line shell to examine the SQLite database .

To install Apache Tomcat, you’ll need Java 1.5 or higher . Download Tomcat from the Apache site. If you are not permitted to install software, download the ZIP file and unzip it to c:     omcat. The blog assumes you have tomcat installed in c:     omcat.</p>h4. Quick Start

The entire Perl environment, perl scripts etc. can be downloaded from the PI_monitor project on Sourceforge.


  1. Download the *perl_with_sapnwrfc.zip *file and extract it to C:strawberry.

Download the pi_monitor.zip file and extract to c:strawberrypi_monitor

Copy c:strawberrypi_monitorMTP.yml to your Edit c:strawberrypi_monitordownload.cmd. Change PXP/PP4 to your server schtasks /create /sc minute /mo 5 /tn “Download SAP Queues” /tr c:strawberrypi_monitordownload.cmd

    This will start collecting data to c:strawberrypi_monitorQueueMonitoring.sqdb (SQLite database). The next steps are needed to adjust the HTML pages to show data of your <sapsids> instead of PXP,EPA and PP4.</p><ol><li>(webpage changes) –Modify c:strawberrypi_monitorwebmonitor.html. Replace EPA/PP4/PXP with the <sapsid> of your servers.</li><li>(iphone webapp changes)* Modify c:strawberrypi_monitorwebindex.html. Replace EPA/PP4/PXP with the The next part (Monitoring XI/PI queues on your iPhone — Part 2 – Retrieving Queue Information from SAP PI with Perl) discusses how to collect queue data from SAP using Perl and RFC functions.

     

     

     

    Assigned Tags

        3 Comments
        You must be Logged on to comment or reply to a post.
        Author's profile photo Former Member
        Former Member
        BASIS PEOPLE CAN MONITOR EVERY WHERE ..

        sorry to ask you the question here . how can i find the item number in the queues.

        for example i transfer one Purcahse request to SRm from ECC . the Purchase request has lot of items but there is no clue about which item has trouble.

        how can functional can read the queue .

        good try . every customer may like this special feature integration.

        Muthu

        Author's profile photo Former Member
        Former Member
        Blog Post Author
        Hi Muthu,
        The queue doesn't have the purchase request information. So take the TID from the queue - and convert it to a message ID - lookup the details in the message with XPATH. See the Super Message Monitor blog to get an example of how to do this.
        Divya
        Author's profile photo Former Member
        Former Member
        Hi Divya

        surprise.if we click the failed queue , we must see the the failed Business Object number like Purchase request. like 1   0   0   0  1  1  2  3 (there are some big intervals in LUW iformation. so that i can identify the BO number but i dont know how to see item number) . can i contact you in offline to discuss.
        XPATH - please expalin how to see them in XPATH.
        How to take the TID . please expalin the super message monitor.
        Thanks for your guidance.
        MUthu