SAP Knowledge Base Article - Preview

2812066 - "SQL Error: 904" when refreshing an EPM report

Symptom

When you refresh an EPM report, the following error is seen:

  • Error: Bad Request
    Error Code: UJ0_READ_EXCEPTION_000
    Description: MDX Statement error: "SQL Error: 904"
    DATAVALUE: SQL Error. 904

If you capture the MDX statement and run it in MDXTEST directly, you see the following error:

  • SQL error: 904. H2.SEQ_NR: Invalid Identifier


Read more...

Environment

  • SAP Business Planning and Consolidation, version for SAP NetWeaver

Product

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 , defect , EPM-BPC-NW-SQE , Shared Query Engine , BW-BEX-OT-DBIF , Interface to Database , 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.