Question Re: SAP PI Message Count in Technology Q&A

SAP PI Message Count

Former Member — Sat, 31 Mar 2018 11:09:07 GMT

HI All,

I need to extract the number of message processed in PI in last 1 Year. Could you please let me know where I can get this information.

I tied Performance monitoring adapter engine but I am getting only 1 month data ,Aggregation interval is showing max 1 day, I am not getting aggregation interval as 1 month.

I tried SXMSPMAST table but, there is no date range as selection criteria.

Java table XI_AF_MSG is showing as invalid table at Open SQL Data Browser: Overview

Could anyone help urgently

Thanks,

Navneet Sumit.

Re: SAP PI Message Count

manoj_khavatkopp — Sat, 31 Mar 2018 12:54:12 GMT

Have you tried in message overview :

Re: SAP PI Message Count

Faison — Mon, 02 Apr 2018 08:27:45 GMT

Hello Navneet Sumit,

Messages in final state (Delivered or Canceled) with expired retention period will be deleted from database by Default Delete job.

Therefore I am not sure if you could find any messages processed last year.

Anyway, you could check this table: BC_MSG

BC_MSG (XI_AF_MSG you mentioned is for PI 7.0x and lower) is the master table for persistence of messages on the Java side, one record per each persistent asynchronous message.

BC_MSG keeps the last (or only) message version created via staging – just for asynchronous messages.

You could use the following SQL statement to check if any messages processed last year could be found.

SELECT * FROM <Java Schema name>.BC_MSG;

More details could be check from following blog:

Introduction of the tables that keep message related data in the database of PI/PO system

Best Regards,

Faison