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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.