cancel
Showing results for 
Search instead for 
Did you mean: 

Table:SRT_MMASTER is growing Rapidly in SID:B4P

former_member862068
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (0)