How To Fix RSDD_ZA156 - Check for physical indexes with no assignment to logical index (InfoCube)

RSDD_ZA156 - Overview

• Message type: E = Error

• Message class: RSDD_ZA - Messages from TREX Aggregate Area

• Message number: 156

• Message text: Check for physical indexes with no assignment to logical index (InfoCube)

What causes this issue?

This check searches for physical indexes that are not assigned to
logical indexes or index joins and are therefore no longer available for
executing BEx queries. Logical indexes or index joins correspond to BW
InfoProviders.
When an InfoProvider is deleted from the SAP NetWeaver BW Accelerator,
some physical indexes of this kind of index join may not be fully
deleted and may remain on the hard disk.
The details for the check provide additional information and list the
names of the indexes that are no longer assigned.

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?

Delete those indexes identified by the check that are no longer assigned
to logical indexes. Contact your system administrator for more
information.
If the system proposes a solution, implement it by following the
instructions.

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 RSDD_ZA156 - Check for physical indexes with no assignment to logical index (InfoCube) ?

  The SAP error message RSDD_ZA156 indicates that there are physical indexes in the system that are not assigned to any logical index in an InfoCube. This situation can lead to inefficiencies in data retrieval and may affect the performance of queries against the InfoCube.
  
  Cause:
  The primary cause of this error is the existence of physical indexes that have not been properly assigned to a logical index. This can occur due to various reasons, such as:
  
  Changes in the InfoCube Structure: If the structure of the InfoCube has been modified (e.g., adding or removing characteristics), the physical indexes may not have been updated accordingly.
  Data Load Issues: If there were issues during data loading processes, it might lead to inconsistencies between physical and logical indexes.
  Manual Deletions or Modifications: Manual changes to the indexes or InfoCube settings can lead to orphaned physical indexes.
  
  
  Solution:
  To resolve the RSDD_ZA156 error, you can follow these steps:
  
  
  Check Index Assignments:
  
  Use transaction