SAP Knowledge Base Article - Preview

3127274 - "Internal error : no result set" when you process a BPC dimension with member formulas

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.