on 04-06-2011 1:52 PM
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can easly count record on integration monitoring table SXMSPMAST selected by interface name.
This is the complete table list:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.