How To Fix RSDD122 - Aggregate &1 adjusted in &2 seconds in the Change Run

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 122

• Message text: Aggregate &1 adjusted in &2 seconds in the Change Run

What causes this issue?

The aggregate &V1& was adjusted in the realignment runs of the
attribute and the hierarchy with the
<DS:GLOS.B1F462336B7DD411BA580800060D888B>delta process</>. 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 RSDD122 - Aggregate &1 adjusted in &2 seconds in the Change Run ?

  The SAP error message RSDD122 indicates that an aggregate has been adjusted during a change run, and it provides information about the time taken for this adjustment. This message is not necessarily an error but rather an informational message that indicates that the system has made adjustments to the aggregate in question.
  Cause:
  The message is triggered when the SAP BW (Business Warehouse) system performs a change run that involves adjusting aggregates. This can happen for several reasons, including:
  
  Changes in the underlying data model or InfoObjects.
  Updates to the data in the InfoProviders that the aggregate is based on.
  Changes in the data that require the aggregate to be recalculated or adjusted to ensure that it remains accurate and up-to-date.
  
  Solution:
  Since RSDD122 is an informational message, it typically does not require any action unless you are experiencing performance issues or unexpected behavior. However, if you want to ensure that the aggregates are functioning optimally, consider the following steps:
  
  Monitor Performance: Keep an eye on the performance of your aggregates. If you notice significant delays or performance degradation, you may need to investigate further.
  Check Data Model Changes: Review any recent changes made to the data model or InfoObjects that could have triggered the aggregate adjustment.
  Rebuild Aggregates: If you suspect that the aggregates are not performing as expected, you can consider rebuilding them. This can be done through the SAP BW administration tools.
  Analyze Change Run Logs: Review the logs of the change run to see if there are any other messages or warnings that could provide additional context.
  Consult Documentation: Refer to SAP documentation or support notes for any specific recommendations related to aggregate adjustments.
  
  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 during query execution.
  Change Run: A change run in SAP BW is a process that updates aggregates and other data structures based on changes in the underlying data.
  Performance Tuning: Regularly monitor and tune your BW system to ensure optimal performance, especially after significant data model changes or large data loads.
  
  If you continue to experience issues or have specific concerns about the performance of your aggregates, consider reaching out to SAP support for further assistance.