SAP Knowledge Base Article - Preview

3076914 - Error executing query when connecting to HANA Calculation View in Crystal Reports for Enterprise

Symptom

  • Error executing query.
  • SQL Error: insufficient privilege, when trying to connect to a Calculation View.
  • When connecting to a HANA Calculation View in Crystal Reports for Enterprise, it fails with the error:

    "Error executing query.
      
     com.sap.db.jdbc.exceptions.JDBCDriverExceprion:... sql processing error: 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...
     Hierarchy cache error:Hierarchy create error for ... error: SQL: insufficient privilege: Details info for this error can be found with guid..."  
       

      Error_Executing_Query.png


Read more...

Environment

  • SAP Crystal Reports for Enterprise 4.2
  • SAP HANA 2.0

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

CRFE, CR4Ent, CR4E, CR for Enterprise , KBA , BI-RA-CRE , Crystal Reports for Enterprise , Problem

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.