3582531 - Various issues when using hierarchy in query

The following different symptoms may occur after loading hierarchy:

• No data return from the query.
• The following error happens when running query:
  Error reading the data of InfoProvider <Name_Of_InfoProvider>$X  
  Error 6.990 has occurred in the BWA/SAP HANA server  
  TREX_DBS_AGGREGATE]  
  Hierarchy source data: Multiple parents not allowed: 10805/[Request Info: Object Name = "SAPHANADB"."0BW:BIA:<Name_Of_InfoProvider>", FM Name = ...  
  Parallel processing of query 1 resulted in the following messages:  
  Parallel processing of query 2 resulted in the following messages:  
  Parallel processing of query 3 resulted in the following messages:  
  Parallel processing of query 4 resulted in the following messages:  
  Errors occurred during parallel processing of query 1, RC: 3  
  Error while reading data; navigation is possible  
  Hierarchy source data: Multiple parents not allowed: 10805.
• Some nodes are assigned as "Not Assigned" in the query.
• Some nodes become duplicated in the query.
• No data returns when running query.

No error or warning occurs when checking the hierarchy in RSH1.

• SAP BW/4 HANA
• SAP S/4 HANA
• SAP NETWEAVER 7.5

KBA , BW4-AE-CORE-HIER , Hierarchies (Runtime) , BW-BEX-OT-OLAP-HIER , Using Hierarchies , Problem