How To Fix RSCV156 - ROOTSID & is missing in inclusion table of hierarchy & version &

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 156

• Message text: ROOTSID & is missing in inclusion table of hierarchy & version &

What causes this issue?

The hierarchy root node (ROOTSID) is not contained in the inclusion
table.

System Response

The hierarchy data for the OLAP processor is incorrect and cannot be
used.

How to fix this error?

The SID is entered for the root node ROOTSID in table RSRHIEDIR_OLAP.
This entry must be available in the inclusion table.
Start the repair in the initial screen or the program
'RRINCLTAB_REBUILD'.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSCV156 - ROOTSID & is missing in inclusion table of hierarchy & version & ?

  The SAP error message RSCV156 indicates that a specific root node (ROOTSID) is missing from the inclusion table of a hierarchy and version in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence). This error typically arises when there is an inconsistency in the hierarchy structure or when the hierarchy is not properly defined.
  Cause:
  
  Missing Hierarchy Node: The specified root node (ROOTSID) is not included in the hierarchy definition, which means that the system cannot find the necessary structure to process the data.
  Incorrect Version: The version specified in the error message may not be correctly set up or may not correspond to the hierarchy being used.
  Data Load Issues: If data loads are not executed correctly, it may lead to missing nodes in the hierarchy.
  Hierarchy Changes: If there have been recent changes to the hierarchy structure (like adding or removing nodes), it may lead to inconsistencies.
  
  Solution:
  
  
  Check Hierarchy Definition:
  
  Go to the hierarchy maintenance transaction (e.g., RSH1 for Hierarchy Maintenance).
  Verify that the root node (ROOTSID) is correctly defined and included in the hierarchy for the specified version.
  
  
  
  Update Inclusion Table:
  
  If the root node is missing, you may need to add it to the inclusion table for the hierarchy and version.
  Ensure that the hierarchy is activated after making changes.
  
  
  
  Check Version Settings:
  
  Ensure that the version you are using is correctly set up and corresponds to the hierarchy you are trying to access.
  
  
  
  Reprocess Data Loads:
  
  If the error occurred after a data load, consider reprocessing the data load to ensure that all necessary nodes are included.
  
  
  
  Review Change Logs:
  
  If there have been recent changes to the hierarchy, review the change logs to identify any modifications that may have led to the error.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or notes related to hierarchy management for additional guidance on resolving this error.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSH1 (Hierarchy Maintenance), RSA1 (Data Warehousing Workbench), and others that may help in managing hierarchies.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Support: If the issue persists, consider reaching out to SAP support for further assistance, providing them with the error details and any steps you have already taken.
  
  By following these steps, you should be able to identify and resolve the issue related to the RSCV156 error message in SAP.