cancel
Showing results for 
Search instead for 
Did you mean: 

Count of no.of files passed for interface

Former Member
0 Kudos

Hi friends,

Can we have a Count of no.of files passed for interface per day..I need it to be an automated process like the no of files interface has processed has to be updated in the daily report.. Can we have it as automated other than manual check.. Is this possible?

Accepted Solutions (1)

Accepted Solutions (1)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Use the report given in this thread

Former Member
0 Kudos

Thanks baskar for the link. it solved a part of my requirement..

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Mahesh,

It would not be automated but you can create a filter criteria for a interface in RWB> Message Monitoring> Selecting the "Message from Component" as Adapter engine/Integration Engine. Select the criteria like interface namespace & services and save it.

When you would like to know the no. of messages processed for day or a week or for a certain period of time then select the Start/End dates & time. Now, you would be able to find the no. of messages processed.

I hope this would be a simple solution for your concern instead of searching for messages in the tables.

Thanks,

Former Member
0 Kudos

Hi Mahesh,

Here are the tables where the message will be stored in tables.

Transaction Codes - (SE11, SE 16)

SXMSPMAS XI Messages - Master

SXMSPHIST XI Messages - Master History table

SXMSPEMAS Integration Engine: Enhanced Message Queue (Master)

SXMSPVERS Integration Engine: Message Version

SXMSPERROR XML Message Broker: Message Queue (Incorrect Entries)

SMPPMAP3 Mapping Runtime: Mapping

SMPPREL3 Mapping Runtime: Mapping Relation

SMPPSPLIT XI Mapping: Merge and Split

SXMSPFRAWH Integration Engine - Header Table for Raw Data for Performance Evaluation

SXMSPFRAWD Integration Engine: Data Table for Raw Data for Performance

Adapter Engine Tables -

Schema Name - SAPSR3DB

XI_AF_MSG AF XI Message

XI_AF_MSG_AUDIT audit log entries

If runing on PI 7.1, table names are as follows -

BC_MSG AF PI 7.1 Message

BC_MSG_AUDIT PI 7.1 audit log entries (**)

Thanks,

Former Member
0 Kudos

You can easly count record on integration monitoring table SXMSPMAST selected by interface name.

This is the complete table list:

http://wiki.sdn.sap.com/wiki/display/XI/XI+Tables

Former Member
0 Kudos

Hi Guys

i couldnt see any selection for interface name..

theres only msgid and pipeline id...

Former Member
0 Kudos

In RWB message monitoring, the Database Overview mode gives the total count of messages processed per interface day/week/month wise both for Integration Engine and Adapter Engine. So this is already done for you, not sure how you can use these values programatically in your reports. Still worth exploring.

Regards,

Suddhasatta