SAP Knowledge Base Article - Preview

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


Read more...

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.