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 , BW4-AE-CORE , Core Services , BW-BEX-OT-OLAP-HIER , Using Hierarchies , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW-BEX-OT-HCPR , CompositeProvider Query , HAN-DB-ENG-TRX , TREX API for SAP HANA Database , BW4-AE-CORE-HIER , Hierarchies (Runtime) , 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.
SAP Knowledge Base Article - Preview