How To Fix RSCV167 - Hierarchy &2 (SIF &1) is defective.

RSCV167 - Overview

• Message type: E = Error

• Message class: RSCV - Analysis of BW objects (InfoCubes...)

• Message number: 167

• Message text: Hierarchy &2 (SIF &1) is defective.

What causes this issue?

The hierarchy entered is faulty.

System Response

Errors arose when executing a query, if this query used the hierarchy.

How to fix this error?

Start the automatic repair, by pressing the pushbutton 'Repair error'
in the initial screen.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSCV167 - Hierarchy &2 (SIF &1) is defective. ?

  The SAP error message RSCV167 indicates that there is a defect in a hierarchy associated with a specific InfoObject (SIF) in the SAP BW (Business Warehouse) system. This error typically arises when there are inconsistencies or issues with the hierarchy structure, which can prevent proper data processing or reporting.
  
  Cause:
  
  Hierarchy Structure Issues: The hierarchy may have been incorrectly defined, or there may be missing nodes or links.
  Data Inconsistencies: There could be inconsistencies in the data that the hierarchy is based on, such as missing or incorrect entries.
  Changes in InfoObjects: If the InfoObject has been modified (e.g., attributes changed, nodes deleted), it can lead to a defective hierarchy.
  Transport Issues: If the hierarchy was transported from one system to another, it may not have been transported correctly.
  
  
  Solution:
  
  Check Hierarchy Definition: Go to the hierarchy maintenance transaction (e.g., RSH1) and check the definition of the hierarchy for any inconsistencies or errors.
  Rebuild the Hierarchy: If the