Symptom
You are connecting successfully to HANA using live connections. However, when trying to connect to a tenant in a multitenant Database container, you receive the error:Error connecting to the system;
Environment
- SAP Analytics Cloud 2017
- SAP multimenant HANA
Reproducing the Issue
You configured reverse proxy using Web Dispatcher or Apache to connect to SAP HANA.
Creating a Live connection to HANA throws the error: Error connecting to the system;
Cause
SAP Analytics Cloud live connections with HANA requires SAP HANA Info Access Service (InA). This is a HTTP service, if your tenants don't have a specific URL, SAP Analytics Cloud will not be able to connect to it.
Resolution
To enable Web-based applications to send HTTP(S) requests to multitenant database containers via the SAP HANA XS classic server, the internal SAP Web Dispatcher must be configured so it knows which requests to dispatch to which database on the basis of DNS alias host names. You do this by specifying the public URL of every tenant database in thexsengine.ini configuration file.
This is the documentation with the required steps:
See Also
- Help resources
- Help portal
- SAP Community ( Questions & Answers / Direct Link to Create Question / Blogs )
- SAP community wiki
- Ideaplace forum ( for enhancement requests & new features )
- Video tutorials
- Videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
- Training events
- Past event recordings
- New user handbook
- Roadmap
- How to connect to on-premise data
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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 , 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