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

RSDD120 - Overview

• 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.

RSDD120 - Details

• 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