Current Position:Home > Exception condition "HIERARCHY_NOT_FOUND" raised. -  SAPLRRHI

Exception condition "HIERARCHY_NOT_FOUND" raised. -  SAPLRRHI

Update:10-11Source: network consolidation
Hello all,
My issue is very similar as the one described in thread : HIERARCHY_NOT_FOUND, but not solved in the other thread.
I tried to update the system to SP21 as told in the topic, but the issue is still present :
when I open a query with the query designer, I'm still having the same issue. Via the RSRT transaction I get the following error message :
Short text
    Exception condition "HIERARCHY_NOT_FOUND" raised.
What happened?
    The current ABAP/4 program encountered an unexpected
Error analysis
    A RAISE statement in the program "SAPLRRHI" raised the exception
    condition "HIERARCHY_NOT_FOUND".
    Since the exception was not intercepted by a superior
    program, processing was terminated.
    Short description of exception condition:
    For detailed documentation of the exception condition, use
    Transaction SE37 (Function Library). You can take the called
    function module from the display of active calls.
Trigger Location of Runtime Error
    Program                                 SAPLRRHI
    Include                                 LRRHIU27
    Row                                     36
    Module type                             (FUNCTION)
    Module Name                             RRHI_ASOHIEDIR_READ
I add that the query use a 0cust_sales based hierarchy, when (at the query level) I remove the time dependance the query works fine, but when I select "type of derivation" in the hierarchy display and use 0D_FC_LM1 : I get the error.
(transaction RSTHJTMAINT--> 0D_FC_LM1 based on 0calmonth and use "first day)
Thanks in advance for help.

The Best Answer

First of all, thanks Maxim to spend time on my issue, it is really appreciated (and sorry for the late answer, I did not have any computers during the week-end).
I checked both tables (SE16 then "number of entries" button) : RSHIEDIR has 5 entries and RSRHIEDIR_OLAP has 9.
So I go to my info-object 0cust_sales, hierarchy tab, "maintain hierarchy" button and reactivate the hierarchy (I only have one line available) and I get the message "There is no modified version for this hierarchy." When I check again the entries number in both tables : no change, (still 5 and 9).
Please find bellow the abap code I get with the message (when I use RSRT) :
Source Code Extract
Line  SourceCde
    6 *"  EXPORTING
    8 *"  EXCEPTIONS
   10 *"----
   11   data: l_hiesid  type rrhi_hiesid,
   12         l_TMPJOIN type rs_bool.
   15     EXPORTING
   16       i_hiesid           = i_hiesid
   17     IMPORTING
   18       E_HIESID_ASO       = l_hiesid.
   20   if l_hiesid < 0.
   21     l_tmpjoin = rs_c_false.
   22   else.
   23     l_tmpjoin = rs_c_true.
   24   endif.
   27     EXPORTING
   28       i_hiesid    = l_hiesid
   29       I_TMPJOIN   = l_tmpjoin
   30     IMPORTING
   31       E_S_HIEDIR  = E_S_HIEDIr
   32     EXCEPTIONS
   33       hierarchy_not_found = 1.
   35   if sy-subrc <> 0.
>>>>>     raise hierarchy_not_found.
   37   endif.
Thanks again and please let me know if you need more informations.
  • Exception condition "HIERARCHY_NOT_FOUND" raised. -  SAPLRRHI Update:10-11

    Hello all, My issue is very similar as the one described in thread : HIERARCHY_NOT_FOUND, but not solved in the other thread. I tried to update the system to SP21 as told in the topic, but the issue is still present : when I open a query with the que

  • Error in BEx Analyzer Exception condition "HIERARCHY_NOT_FOUND" raised. Update:10-11

    When i run report 0FIAA_C02_Q1001 with input variable as  "My controlling area" i get this error. ERROR: Exception condition "HIERARCHY_NOT_FOUND" raised. ERROR Analysis: A RAISE statement in the program "SAPLRRH1" raised the

  • Exception condition "HIERARCHY_NOT_FOUND" Update:10-11

    Hello, we have scenario in Xcelsius where we used QAAWS with different queries. after upgrading to the EhP1 (BW System) we strated getting WIS errors in QAAWS tool wrt 0country hierarchy even though there are no hierarchies activated in queries. I re

  • Short Dump, Exception condition "NOT_EXIST" raised Update:10-11

    Dear Colleagues! I am having a problem with short dump, I am getting the message Exception condition "NOT_EXIST" raised. I am trying to load data to ODS with full load and filtering via a DTP. In the monitoring the load doesn't even get started.

  • "Exception condition "CONTROL_FLUSH_ERROR" raised." during background jobs Update:10-11

    hi all, the program ZTEST is used for downloading a txt file into D: using GUI_DOWNLOAD. this program works fine but when I schedule this porgam in background jobs in tcode SM36 using "job wizard", i am getting errors as  Exception condition &qu

  • Exception condition "CONVERSION_ERROR" raised. Update:10-11

    Hi, We have been getting short dumps in our production system daily. I was unable to locate the problem by looking at the dump. The dump says that CONVERSION_ERROR raised. Which application raised this exception? Again no clue on the same. Please fin

  • Exception condition "FAILED" raised. Update:10-11

    My TRM functional consultant has been trying to run end of day processes in the Transaction RKLNACHT but the following dump appears: Runtime Errors         RAISE_EXCEPTION                                                              Date and Time    

  • Exception condition "CNTL_ERROR" raised.  in WDA :  smartform to pdf Update:10-11

    Hii,  I am using a webdynpro - abap application. I am showing  a smartform as a pdf in one on the windows. When the link in the main window is clicked, a secondary window. Instead of the pdf, I get following exception.Kindly help me understand, where

  • Exception condition "CONFIG_NOT_FOUND" raised. Update:10-11

    Hi, I am trying to create an Opportunity in CRM 7.0 WEB UI. The moment i click on the create opportunity, i am getting a pop window, showing the transaction types which i have created in spro. But when i am selecting any one of them, i am getting a d

  • Exception Condition "Fatal_Error" Raised in SMQ2 Update:10-11

    Hi, I am doing File to Proxy(ECC) Asynchronous scenario. in this getting the error in Target side(ECC) in SMQ2 message is showing error , when I double click on this error getting the error message like  Exception Condition "Fatal_Error" Raised.