SAP Knowledge Base Article - Preview

2527997 - [Error] Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

Symptom

When you speciy level hierarchies in the Excel MDX (Drag and drop to the columns or rows fields), Excel generates error message saying:

3.PNG

If you see the index server trace, you will find the similar error message saying:

[8784]{324979}[38/-1] 2017-08-31 09:32:39.752445 e hierarchies      Exceptions.cpp(00019) : Exception occurred: exception  1: no.75000001  (hierarchies/InternalData.cpp:248)

    Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

[8784]{324979}[38/-1] 2017-08-31 09:32:39.752496 e mdx              hierarchyCacheManager.cpp(01209) : Hierarchy create error for "_SYS_BIC"."MTP/TIME_DIM/hier/HI_TIME" error: exception 75000001: Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

[8784]{324979}[38/-1] 2017-08-31 09:32:39.752821 e mdx              Executor.cpp(00183) : Error occurred while executing a MDX statement. The error message is: An internal error occurred. Assertion failed with error message Hierarchy cache reference is invalid for [TIME_DIM].[HI_TIME] : Hierarchy cache error:Hierarchy create error for "_SYS_BIC"."MTP/TIME_DIM/hier/HI_TIME" error: exception 75000001: Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified


Read more...

Environment

HANA Database server revision: 122.11
HANA Studio version: 2.3.27

Keywords

MDX, Modeling, Level Hierarchy, nodestyle, name_only , KBA , HAN-DB-MDX , SAP HANA MDX Engine/Excel Client , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , 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.