2613461 - "Database error 256 at EXE sql processing error: Error occurred while executing a MDX statement" when requesting data on node level or processing a dimension - BPC NW

Symptom

When requesting data on node level or processing a dimension the user gets the following error:

"Database error 256 at EXE sql processing error: Error occurred while executing a MDX statement.

The error message is: Cube XXX could not be found. Please check if the Cube is valid and exists. The detail error message: Column View SAPSR3:$BPC$V$OLAP_Y5IHRNCen for cube XXX is not valid"

Reports on base level work perfectly.
When accessing the same data from the BW side (Using analysis on the BPC cube) everything works fine.
When running UJA_DATA_CHECKER user gets errors on all dimensions containing member formulas. These errors ressemble to the error mentioned in the SAP KBA 2490777 . However, the files in UJFS do exist

Environment

SAP Business Planning and Consolidation 10.1 version for SAP NetWeaver
SAP Business Planning and Consolidation 11.x, version for SAP BW/4HANA
SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA
SAP Business Planning and Consolidation 2023, version for SAP BW/4HANA

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA ; SAP NetWeaver 7.4

Keywords

EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, Database error 256 at EXE, sql processing error, SAPSR3:$BPC$V$OLAP_Y5IHRNCen, BW4HANA, , KBA , EPM-BPC-NW-ADM , Admin , 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.