SAP PI Message Count

[former_member433852]

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.

[Faison]

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

[manoj_khavatkopp]

Have you tried in message overview :