on 09-14-2023 11:15 AM
As We can see that table: SRT_MMASTER is having more then 100 GB of data right now and This table contain the log from Web services.
Job: SAP_SOAP_RUNTIME_MANAGEMENT is running in PRD as per SAP NOTE: 2231932 – ESI – How to schedule the SAP_SOAP_RUNTIME_MANAGEMENT standard background job
On further checking We have found that log will be saved in Table: SRT_MMASTER until 45 days and it will deleted . So, we will have data of 45 days in PRD system. find the configuration Screen shot for same.
Please find the Reference SAP NOTE: 2976543 - SRT* table content cannot be cleaned.
On further checking the table: SRT_MMASTER content, we have found that there are a lot of Status: System errors and has attachments that are bigger in size.
We know these logs are not useful for us and we wanted to delete those logs for a certain period we have tried to delete them, but we cannot delete the consumer log from Table: SRT_MMATER.
Further checking I have found the below SAP NOTE and canceled those errors, but the cancel log has not been deleted from SAP system Quality SAP System by Job: SAP_SOAP_RUNTIME_MANAGEME as we are testing in Quality system system.
2670185 - ESI - SXMB_MONI: Message cannot be deleted from consumer endpoint
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.