3331022 - Error "306105: Invalid query. Failed to find '<navigation_attribute>_KEY' at node '0BW:BIA:<HCPR_technical_name>'"

Symptom

Error during HCPR data display in LISTCUBE:

Instantiation of calculation model failed;exception 306105: Invalid query. Failed to find '<navigation_attribute>_KEY' at node ...
'0BW:BIA:<HCPR_technical_name>' /[Request Info: Object Name = "SAPHANADB"."0BW:BIA:<HCPR_technical_name>", FM Name = TREX_DBS_AGGREGATE]
Error 34.023 has occurred in the BWA/SAP HANA server
Error reading the data of InfoProvider <HCPR_technical_name>$X
Error in BW: _HCPR_PROCESS-3-

The relevant fields are mapped correctly and the HCPR is free from relevant CMP problems.

_KEY' at node '0BW:BIA:'""> Read more...

Environment

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

Product

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

Keywords

"306105" "Invalid query" "Failed to find" "navigation attribute" "KEY" "34.023" "column view" , KBA , BW4-DM-HCPR , Composite Provider , BW-BEX-OT-HCPR , CompositeProvider Query , 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.