How To Fix RSDD121 - Aggregate &1 rolled up in &2 seconds

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 121

• Message text: Aggregate &1 rolled up in &2 seconds

What causes this issue?

New data was <DS:GLOS.364FFAFAF9FC022FE10000009B38F9B6>rolled up</>
from the InfoCube in the aggregate &V1&. 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
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 RSDD121 - Aggregate &1 rolled up in &2 seconds ?

  The SAP error message RSDD121, which states "Aggregate &1 rolled up in &2 seconds," is not necessarily an error but rather an informational message indicating that an aggregate has been successfully rolled up in a specified amount of time. This message typically appears in the context of data warehousing and reporting in SAP BW (Business Warehouse).
  Cause:
  
  Aggregate Roll-Up Process: The message is generated during the process of rolling up data into an aggregate. Aggregates are pre-calculated summaries of data that improve query performance by reducing the amount of data that needs to be processed during reporting.
  Performance Monitoring: The message serves as a performance indicator, showing how long it took to roll up the aggregate. It can be useful for monitoring the efficiency of data processing.
  
  Solution:
  Since this message is informational, there is no direct solution required unless you are experiencing performance issues. However, if you want to optimize the roll-up process or address any underlying concerns, consider the following:
  
  
  Performance Tuning: If the roll-up time is longer than expected, investigate the following:
  
  Data Volume: Check the volume of data being processed. Large datasets can lead to longer roll-up times.
  System Resources: Ensure that the SAP BW system has adequate resources (CPU, memory, etc.) to handle the data processing efficiently.
  Indexing: Ensure that appropriate indexes are in place to speed up data retrieval and processing.
  Aggregate Design: Review the design of your aggregates. Sometimes, simplifying the aggregate or reducing the number of characteristics can improve performance.
  
  
  
  Monitoring: Use transaction codes like RSRT (Query Monitor) or RSD1 (InfoObject Maintenance) to monitor the performance of your aggregates and queries.
  
  
  Regular Maintenance: Regularly perform maintenance tasks such as data archiving, updating statistics, and optimizing aggregates to ensure optimal performance.
  
  
  Related Information:
  
  SAP BW Documentation: Refer to the official SAP documentation for more details on aggregates, roll-up processes, and performance tuning.
  SAP Community: Engage with the SAP Community forums for discussions and insights from other users who may have encountered similar messages.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSA1 (Data Warehousing Workbench) for managing aggregates and monitoring performance.
  
  In summary, the RSDD121 message is informational and indicates the time taken for an aggregate roll-up. If performance issues arise, consider the suggestions above to optimize the process.