3733773 - unexpected error 2120042 when selecting hierarchy in analytic model preview

Error in Analytical Model; unexpected error appears when a hierarchy is selected in an analytic model preview: "Caught exception: exception 2120042: An unexpected error occurred."

When checking the indexserver trace, you see below error:

[75483]{241651}[1485183/-1]<19ac0b49d946b17f3903e3346502753a#428dac6341618da8> 2025-11-26 15:12:20.583515 d mds HierarchyImplSql.cpp(00083) : Instantiate SQL hierarchy with view - schemaName=<schema_name> name=§<hierarchy> with placeholders=[]
[75483]{241651}[1485183/-1]<19ac0b49d946b17f3903e3346502753a#428dac6341618da8> 2025-11-26 15:12:56.642652 E Assure HierarchyImplSql.cpp(00489) : The following assertion failed: aMaxMemberId < 20000000u
aMaxMemberId = 22598369
20000000u = 20000000
Hierarchy has too many nodes
Correlation id is 0x48dfc85342837be6

SAP HANA 1.0
SAP HANA 2.0
SAP HANA Cloud

exception 2120042, analytic model preview, hierarchy selection error, unexpected error, mds, ina, hana multidimensional services, too many nodes, hierarchy limit, member id limit, amaxmemberid assertion, hierarchy overflow, sap datasphere analytic model, data builder preview, hierarchy filtering, Hierarchy has too many nodes , KBA , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , Problem