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

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP NetWeaver 7.4

Keywords

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.