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 follows 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 HANA  index server trace, you may find errors such as the follows :

    ... 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

Product

SAP BW/4HANA all versions ; SAP NetWeaver 7.5

Keywords

2999, H000, H001, H002, H003, H004, PRED, SUCC , 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 ONE Support launchpad (Login required).

Search for additional results

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