How To Fix RSDD120 - Aggregate &1 rebuilt in &2 seconds

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 120

• Message text: Aggregate &1 rebuilt in &2 seconds

What causes this issue?

The aggregate &V1& was rebuilt. In addition &V3& records were read, and
&V4& records were written.
The database required &V2& seconds to read and write.
This time data does <ZH>not</> include the following processes:
index structure
database statistics structure
compression

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 RSDD120 - Aggregate &1 rebuilt in &2 seconds ?

  The SAP error message RSDD120, which states "Aggregate &1 rebuilt in &2 seconds," is not actually an error in the traditional sense. Instead, it is an informational message indicating that an aggregate has been rebuilt successfully in the specified amount of time. This message typically appears in the context of SAP BW (Business Warehouse) when aggregates are being processed.
  Cause:
  The message is triggered when the system rebuilds an aggregate for a particular InfoCube or data model. This can happen for several reasons, including:
  
  Changes in the underlying data model or InfoObjects.
  Updates to the data that require the aggregate to be refreshed.
  Scheduled jobs or manual triggers to optimize performance.
  
  Solution:
  Since this message is informational, there is no specific "solution" required. However, if you are seeing this message frequently and are concerned about performance, you might consider the following actions:
  
  Review Aggregate Strategy: Ensure that your aggregate strategy is optimized. You may want to evaluate which aggregates are necessary and whether they are being used effectively.
  Monitor Performance: Keep an eye on the performance of your queries. If you notice slow performance, it may be worth investigating the underlying data model or the frequency of aggregate rebuilds.
  Schedule Rebuilds: If aggregates are being rebuilt too frequently, consider scheduling the rebuilds during off-peak hours to minimize the impact on system performance.
  Check for Data Changes: If the aggregate is being rebuilt due to frequent data changes, assess whether the data loading process can be optimized.
  
  Related Information:
  
  SAP BW Aggregates: Aggregates are pre-calculated summaries of data that improve query performance by reducing the amount of data that needs to be processed at runtime.
  Transaction Codes: You can use transaction codes like RSA1 (Data Warehousing Workbench) to manage and monitor aggregates.
  Performance Tuning: Regularly review and tune your BW system for optimal performance, including the use of aggregates, indexes, and partitioning strategies.
  
  In summary, the RSDD120 message is a normal part of the operation of SAP BW and indicates that the system is maintaining its performance by rebuilding aggregates as needed.