SAP Knowledge Base Article - Preview

3582531 - Various issues when using hierarchy in query

Symptom

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.
  • Expanding hierarchy nodes doesn't work. No child nodes are displayed. 
  • Not a valid hierarchy as at least one IndexAliasOperation is incorrect /[Request Info: Object Name = " "
  • Hierarchy source data: Duplicate successor node ID(s);Hierarchy source data: Multiple parents not allowed: 35273: calcEngine search on olapIndex ... 

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


Read more...

Environment

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

Product

SAP BW/4HANA all versions ; SAP NetWeaver all versions ; SAP S/4HANA all versions

Keywords

Error 6990 has occurred in the BWA/SAP HANA server, Hana hierarchy, Hana hierarchies, hierarchy inconsistency, hierarchy missing data, hierarchy no data, Not a valid hierarchy as at least one IndexAliasOperation is incorrect /[Request Info: Object Name,  Not a valid hierarchy as at least one IndexAliasOperation is incorrect, wrong data, Error, Query, incorrect result, incorrect data, incorrect, missing data, missing information, missing, hierarchy buffers , KBA , BW4-AE-CORE-HIER , Hierarchies (Runtime) , BW-BEX-OT-OLAP-HIER , Using Hierarchies , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.