SAP Knowledge Base Article - Preview

1964185 - MDX validation error when ENABLING HANA MDX parameter

Symptom

  • Intermittent MDX execution validation errors when enabling ENABLE_HANA_MDX parameter: 

UJA_DATA_CHECK     E                060 Invalid measure formula existed in model Rates
UJO_READ_EXCEPTION E                000 MDX statement error:"MDX SYNTAX CHECK WITH##  MEMBER [Measures].[PERIOD"
                   E                000 Internal error : no result set

  • Error message when running the MDX statement directly on HANA STUDIO:


Could not execute 'MDX WITH MEMBER [Measures].[PERIODIC] AS ...'
SAP DBTech JDBC: [256]: sql processing error: Error occurred while executing a MDX statement. The error message is: illegal metadata object access (object was already deallocated or this transaction is not the transaction of object creator). trans id: 41 trans state: 1 trans type: 0


Read more...

Environment

SAP Business Planning and Consolidation 10.0 SP05 to SP07, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

Keywords

enablehanamdx enablehana ujhana , KBA , EPM-BPC-NW-SQE , Shared Query Engine , EPM-BPC-NW-PM , Parameter Maintenance , 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.