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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.