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
- 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
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.