How To Fix RSDD123 - Aggregate &1 adjusted in &2 seconds when deleting data

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 123

• Message text: Aggregate &1 adjusted in &2 seconds when deleting data

What causes this issue?

When data was deleted, the aggregate &V1& was adjusted. In addition,
&V3& records were read, and &V4& records were written.
The database required &V2& seconds to read and write.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDD123 - Aggregate &1 adjusted in &2 seconds when deleting data ?

  The SAP error message RSDD123, which states "Aggregate &1 adjusted in &2 seconds," typically occurs in the context of data deletion in SAP BW (Business Warehouse) when working with aggregates. This message is not necessarily an error but rather an informational message indicating that an aggregate has been adjusted (or recalculated) during the data deletion process.
  Cause:
  
  Data Deletion: When you delete data from a fact table, the aggregates that depend on that data need to be recalculated to ensure that they reflect the current state of the data.
  Performance Impact: The adjustment of aggregates can take time, especially if the aggregates are large or complex, which is why the message includes the time taken for the adjustment.
  
  Solution:
  
  
  Monitor Performance: If the adjustment time is excessive, you may want to monitor the performance of your aggregates and consider optimizing them. This can include:
  
  Reducing the number of aggregates.
  Ensuring that aggregates are designed efficiently.
  Regularly maintaining and optimizing the database.
  
  
  
  Schedule Data Deletion: If the deletion process is impacting system performance, consider scheduling data deletions during off-peak hours to minimize the impact on users.
  
  
  Check Aggregate Settings: Review the settings of the aggregates to ensure they are configured correctly. Sometimes, unnecessary aggregates can be removed or consolidated.
  
  
  Use Compression: If you are frequently deleting data, consider using data compression techniques to improve performance.
  
  
  Update Statistics: Ensure that database statistics are up to date, as this can help the database optimizer make better decisions regarding query execution plans.
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes related to performance issues with aggregates and data deletion for any specific recommendations or patches.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSA1 (Data Warehousing Workbench) for managing aggregates and monitoring performance.
  Documentation: Review SAP BW documentation for best practices on managing aggregates and data deletion processes.
  
  In summary, while the RSDD123 message indicates that an aggregate has been adjusted, it is essential to monitor the performance and optimize the aggregates to ensure efficient data management in SAP BW.