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, 2.0, 2021
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.