1932002 - Crystal Reports for Enterprise gives "root node not found" when reporting from a HANA Parent Child Hierarchy

SAP Crystal Reports for Enterprise 4.1 gives the following error message when reporting from a HANA Analytic View containing a parent child hierarchy via MDX

Error executing query

ErrorCode: 256
Message: SAP DBTech JDBC: [256]: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube AN_PCHIER_ZEROROOT could not be found. Please check if the Cube is valid and exists. The detail error message: Hierarchy not found in hierarchy cache [AT_PCHIER_ZEROROOT].[PCHIER_ZEROROOT] error: Internal error during hierarchy processing;Specified root node not found in hierarchy predecessor data Dimension [AT_PCHIER_ZEROROOT] hierarchy [AT_PCHIER_ZEROROOT].[PCHIER_ZEROROOT]

 

Read more...

• SAP Crystal Reports for Enterprise 4.1 or higher
• SAP HANA

SAP BusinessObjects Business Intelligence platform 4.1

• OLAP
• Hierarchical
• Exception

, KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , HAN-DB-MDX , SAP HANA MDX Engine/Excel Client , Problem