SAP Knowledge Base Article - Preview

1999110 - Invalid measure formula existed in model when ENABLE_HANA_MDX is set to X

Symptom

  • Setting model parameter ENABLE_HANA_MDX = X generates the following error:

UJA_DATA_CHECK Invalid measure formula existed in model <ModelName>
UJO_READ_EXCEPTION MDX statement error:"MDX SYNTAX CHECK WITH MEMBER [Measures].[PERIOD"
Internal error : no result set

error.PNG

  • the system hangs with this error and the program needs to be terminated to close.
  • This error occurs on only RATE model.
  • SLG1 at the time of error showed: SQL execution error: DROP VIEW "SAPBHD"."$MDX/ENVSHELL_COPY_Rates/SAPBHD/$BPC$V$OLAP_AAIRTOG/CATEGORY/hier/PARENTH1"
  • NOTE 1959207, 1976552, and 1990983 are applied to the system, however the issue persists.
  • Running MDX statement from SLG1 directly on HANA STUDIO generates the following error:

Could not execute 'MDX SYNTAX CHECK WITH MEMBER [Measures].[PERIODIC]
AS ...' in 160 ms 54 µs .
SAP DBTech JDBC: [256]: sql processing error: Error occurred while
executing a MDX statement. The error message is: An internal error
occurred. Assertion failed with error message Property /CPMB/ACCTYPE is
not a valid property of hierarchy [R_ACCOUNT].[PARENTH1]

  • You may also get error in the HANA DB log
    [1858]{253555}[32/-1] 2017-02-24 01:37:28.800505 e mdx Executor.cpp(00183) : Error occurred while executing a MDX statement. The error message is: Syntax Error : ...], [RPTCURRENCY].[PARENTH1].&[EUR]) WITH<<<

Read more...

Environment

  • SAP BusinessObjects Planning and Consolidation version 10 for SAP NetWeaver 7.31
  • SAP BusinessObjects Planning and Consolidation version 10.1 for SAP NetWeaver

Product

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

Keywords

SAP & SYSID, schema name, SQL execution error,  invalid property, dimension member formula , KBA , defect , troubleshooting , EPM-BPC-NW-SQE , Shared Query Engine , BW-PLA-BPC , BPC 'embedded model' , Bug Filed

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.