How To Fix RSD_TREX114 - Index of table '&1' must be created again

RSD_TREX114 - Overview

• Message type: E = Error

• Message class: RSD_TREX - Messages from TREX Aggregate Area

• Message number: 114

• Message text: Index of table '&1' must be created again

What causes this issue?

The structure of the index for the table has changed. Thus the index
must be created again.

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.

RSD_TREX114 - Details

• The SAP error message RSD_TREX114 indicates that the index of a specific table (denoted by &1) must be recreated. This typically occurs in the context of SAP BW (Business Warehouse) when there are issues with the underlying data or the index structure used by the TREX search engine.
  
  Cause:
  
  Data Changes: The underlying data in the InfoProvider may have changed significantly, necessitating a re-indexing.
  Corruption: The index may have become corrupted due to system issues or inconsistencies in the data.
  Configuration Changes: Changes in the configuration of the InfoProvider or the TREX settings can lead to the need for re-indexing.
  System Upgrades: After an upgrade, the existing indexes may not be compatible with the new system version.
  
  
  Solution:
  To resolve the RSD_TREX114 error, you can follow these steps:
  
  
  Recreate the Index:
  
  Go to the SAP BW system.
  Navigate to the relevant InfoProvider (e.g., InfoCube, DataStore Object).
  Use the transaction code RSD1 to access the InfoProvider.
  Select the InfoProvider and choose the option