How To Fix RSDD091 - The indices from aggregate &1 must be checked

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 091

• Message text: The indices from aggregate &1 must be checked

What causes this issue?

The <LS>High Cardinality</> property has been changed in one dimension
of aggregate &V1&. In some databases, the database index that is used
depends on this property. However, this index has not been modified.

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?

Check the indexes and, if necessary, rebuild them. Go to transaction
RSRV and choose <LS>All Elementary Tests -> Database -> Database Indexes
of an InfoCube and Their Aggregates </>.

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 RSDD091 - The indices from aggregate &1 must be checked ?

  The SAP error message RSDD091 indicates that there is an issue with the indices of an aggregate in the SAP BW (Business Warehouse) system. This message typically arises when the system detects inconsistencies or problems with the aggregate's indices, which can affect performance and data retrieval.
  Cause:
  The error can be caused by several factors, including:
  
  Data Inconsistencies: Changes in the underlying data or structure of the InfoProvider that the aggregate is based on.
  Incomplete or Failed Aggregation: If the aggregation process did not complete successfully, it may leave the indices in an inconsistent state.
  Database Issues: Problems with the database that prevent the indices from being accessed or updated correctly.
  Changes in the InfoObject: Modifications to the InfoObjects used in the aggregate can lead to inconsistencies.
  
  Solution:
  To resolve the RSDD091 error, you can follow these steps:
  
  
  Check the Aggregate:
  
  Use transaction code RSA1 to access the Data Warehousing Workbench.
  Navigate to the InfoProvider and locate the aggregate that is causing the issue.
  Right-click on the aggregate and select "Manage" or "Check" to analyze the aggregate.
  
  
  
  Rebuild the Indices:
  
  If the check indicates issues, you may need to rebuild the indices. This can be done by:
  
  Right-clicking on the aggregate and selecting "Rebuild Indices" or "Rebuild".
  This process will recreate the indices and resolve any inconsistencies.
  
  
  
  
  
  Check for Data Load Issues:
  
  Ensure that there are no ongoing data load processes that might be affecting the aggregate.
  If there are, wait for them to complete and then recheck the aggregate.
  
  
  
  Monitor Database Performance:
  
  Check the database for any performance issues or locks that might be affecting the aggregate.
  Consult with your database administrator if necessary.
  
  
  
  Transport Issues:
  
  If the issue arose after a transport, ensure that all related objects were transported correctly.
  
  
  
  SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that might address this specific error or provide additional troubleshooting steps.
  
  
  
  Related Information:
  
  Transaction Codes: 
  
  RSA1: Data Warehousing Workbench
  RSD1: InfoObject Maintenance
  RSD2: InfoProvider Maintenance
  
  
  Documentation: Refer to SAP Help documentation for more details on aggregates and performance tuning in SAP BW.
  Support: If the issue persists after following the above steps, consider reaching out to SAP Support for further assistance.
  
  By following these steps, you should be able to resolve the RSDD091 error and ensure that your aggregates are functioning correctly.