Can't update priceList in SAP without SAP crashing due to memory issue being caused by CXS_Ivend_SP_

Can't update priceList in SAP without SAP crashing due to memory issue being caused by CXS_Ivend_SP_

Problem Statement 

When a user is trying to update a price list name in SAP,  it will freeze for 20 minutes or longer and then the system will crash. There is enough free space but every time the system crashes it is due to memory issues. 


Proposed Solution 

1.Check  the db fragmentation . if high make it low

2.Check the rep integration log table whether the junk data is there or not if junk data is present in table remove the junk data