Objective:–
To track and email Replication related errors and send it to the end users / support team members on a periodic basis. This feature is a nice to have feature where the users have a comfort not to go to the slg1 transaction or to open the data replication monitor in EC frequently. This feature comes in handy when the errors occurs in data replication and the team wants it to flow to their inbox.
Approach :-
This can be done in following ways:-
In this blog we will cover the point number 2 sated above.
The approach is as below.
Create an Aabap Program to read the SLG1 logs using built in function modules.
The screen also has time restriction as to how much back in time the user wants the log to be retrieved.
The last section of the screen is the email related parameter.
Here we have enhanced two things
This program can be scheduled in the background for any frequency or can be also linked with some event that occurs post replication program run.
Below function modules can be referred and used
BAL_DB_LOAD
BAL_LOG_MSG_READ
The message type “E” can be filtered and then those selected messages can be formatted as per need and sent to the email body.
Conclusion: –
This is a small but very useful utility for error monitoring for employee / org replication. This can be further enhanced for the email body or email attachment formatting as needed.