SAP Knowledge Base Article - Public

2546847 - SAP Live Data Connection query stops responding in SAP Analytics Cloud (BOC)

Symptom

SAP Live Data Connection query stops responding in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Connect to SAP Analytics Cloud
  2. Create a Live Data Connection to SAP HANA
  3. Create a Model from an SAP HANA View using the Live Data Connection
  4. Create a Story from the Model
  5. Notice the query from the Story never returns from SAP HANA 

Cause

SAP HANA View has an error in it.

Resolution

  1. Start SAP HANA Studio to validate <YOURPACKAGE>.<YOURHANAVIEW>
  2. Connect to the system
  3. Expand Content
  4. Right-Click <YOURPACKAGE> and choose Filter Objects...
  5. Enter Filter Text <YOURHANAVIEW> and click OK
  6. Right click on <YOURHANAVIEW> and choose Validate
  7. Address any issues reported by Validate

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Studio, Validate, Error, Hang , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0