SAP Knowledge Base Article - Preview

2919693 - Error related to attribute "H000.PRED" when executing a BW Query

Symptom

  • When executing a BW Query involving hierarchy handling, errors such as the following occur:

    --------------------------------------------------------------------
    Error reading the data of InfoProvider ...
    Error message Object Collapsed Error 2.999 has occurred in the BWA/SAP HANA server
    Error message Object Collapsed .../[Request Info: Object Name = ..., FM Name = TREX_DBS_AGGREGATE]
    Error message Object Collapsed general error (no further information available);Failed to receive table info ... 
    Error message Object Collapsed Parallel processing of query 7 resulted in the following messages:
    Error message Object Collapsed general error (no further information available);Failed to receive table info ... '
    ...
    Error message Object Collapsed Errors occurred during parallel processing of query 8, RC: 3

    --------------------------------------------------------------------

    L_RETURN_CODE: 2920
    L_RETURN_TEXT: multiprovider schema is not consistent;Could not initialize requested attributes of part provider "SAPABAP:0BW:BIA:XXX": No valid mapping defined for attribute "H000.PRED": calcEngine search
    or
    L_RETURN_TEXT: multiprovider schema is not consistent;Could not map query entry to part provider: No mapping found for attribute "H002.SUCC" and part provider ... 


  • In the indexserver trace, you may find errors such as:

    ... e ceQo ceQOBuilder.cpp(01153) : Failed to receive table info ...
    ... e ceQo ceQOExecutor.cpp(00446) : ceQOExecutor::execute: Failed to build QO tree
    ... e SERVER_TRACE TRexApiSearch.cpp(06106) : IndexID: ... (t -1), QueryMediator failed executing query, reason: Could not initialize requested attributes of part provider ...: No valid mapping defined for attribute "H000.PRED"
    ... e ceExecute cePopAggregation.cpp(04216) : Could not initialize requested attributes of part provider ... : No valid mapping defined for attribute "H000.PRED": calcEngine search on olapIndex failed.


Read more...

Environment

  • SAP NetWeaver 7.5
  • SAP BW/4HANA 1.0
  • SAP BW/4HANA 2.0
  • SAP BW/4HANA 2021
  • SAP BW/4HANA 2023

Product

SAP BW/4HANA all versions ; SAP NetWeaver 7.5

Keywords

2999, H000, H001, H002, H003, H004, PRED, SUCC, "multiprovider schema is not consistent;Could not map query entry to part provider: No mapping found for attribute "H000.PRED" and part provider" , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-OLAP-HIER , Using Hierarchies , BW4-AE-CORE , Core Services , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW4-AE-CORE-HIER , Hierarchies (Runtime) , BW-BEX-OT-HCPR , CompositeProvider Query , HAN-DB-ENG-TRX , TREX API for SAP HANA Database , 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.