Symptom
When you process a dimension, it fails with “Internal error : no result set” .
If you run program UJA_DATA_CHECKER, you see the following error:
- UJA_DATA_CHECK E 057 Invalid member formula existed in dimension xxx
UJO_READ_EXCEPTION E 000 MDX statement error:"MDX SYNTAX CHECK WITH
MEMBER [xxx].[PARENTH"
E 000 Internal error : no result set
The following message can be seen in SM21:
- BY2 Database error -9300 at OPC
BY0 > Internal error : no result set
In DB02 -> indexserver_alert_xxxxxxxxx.trc, the following error is recorded:
- [Set: {(...)}] expects a parameter that returns a [Member, Tuple, Set, Null]. [Binary operator: +] returns a Numeric
Read more...
Environment
- SAP Business Planning and Consolidation, version for SAP NetWeaver
- SAP Business Planning and Consolidation, version for SAP BW/4HANA
Product
SAP Business Planning and Consolidation, version for SAP BW/4HANA all versions ; SAP Business Planning and Consolidation, version for SAP NetWeaver all versions
Keywords
EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , EPM-BPC-BW4-INF-SQE , BPC/4 - Shared Query Engine , EPM-BPC-NW-SQE , Shared Query Engine , 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.