SAP Knowledge Base Article - Public

2628688 - OData service connection in SAP Analytics Cloud ***Collective KBA***

Symptom

  • This article summarizes common error messages when connecting to an OData service in SAP Analytics Cloud (SAC) for importing data into SAP Analytics Cloud.
  • You have followed the steps to set up an OData service URL and an Import Data connection as per the online help Import Data Connection to OData Services
  • Some error messages occur when connecting to an OData service in SAP Analytics Cloud, for example:
    • Unable to connect to OData Services with error: 503 There is no SAP Cloud Platform Cloud Connector (SAPCP CC / SCC) connected to your subaccount. Requested opening of a tunnel for subaccount <name of your subaccount> and default SCC location ID, that is, empty string or simply not configured. Check the configuration on SCC and cloud side.. Check the connection details and user credentials then try again.
    • Unable to connect to OData Services with error: Error sending request to proxy. Status: 403 Reason: Forbidden. Check the connection details and user credentials then try again.
    • Unable to connect to OData Services with error: 502 The requested URL could not be retrieved. Check the connection details and user credentials then try again.
    • The user doesn't have permission to access the requested resource.
    • The request is unauthorized, please check data service url and credentials.
    • Unable to connect to OData Services with error: response status 404. Check the datasource URL and on-premise option then try again.
    • Authentication is required. Please select one authentication type.
    • Unable to connect to OData Services with error: 503 Application Server Error. Check the connection details and user credentials then try again.
  • Other errors in the Chrome developer tools may also occur, for example:
    • {"result":"{\"error\":{\"code\":\"ERROR_ACCESS_DENIED\",\"rawError\":\"Forbidden Access denied to system <SERVER>:443. In case this was a valid request, ensure to expose the system correctly in your cloud connector.\",\"params\":[]}}"}

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

Follow the steps in the online help Import Data Connection to OData Services 

  1. For an on-premise OData service host http://<HOST>:<PORT>/<Package>/<Service>, create the following mapping entry:

    1. In the SAP Cloud Platform (CP) Cloud Connector navigation panel, select Cloud to on-premise.
    2. Under the Access Control tab, select + (Add)
    3. Fill in the Edit System Mapping dialog:
      • Back end Type: Other SAP System
      • Protocol: HTTP (or HTTPS depending on whether you implemented SSL)
      • Virtual Host: <HOST>
      • Virtual Port: <PORT>
      • Internal Host: <HOST>
      • Internal Port: <PORT>
      • SAProuter: <leave empty>
      • Principal Type: None
      • SNC Partner Name: <leave empty>
      • Description: OData service host
      • Check Internal Host: [Checked]
    4. Click Save
      NOTE: When you specify the Data Service URL = http://<HOST>:<PORT>/ in SAP Analytics Cloud, it will use the SAPCP Cloud Connector to look up the  <HOST>:<PORT> specified in <Virtual Host>:<Virtual Port> and route the request to the <Internal Host>:<Internal Port>.
    5. Select the system you added to the Mapping Virtual To Internal System list
    6. In the Resources Accessible area, select + (Add)
    7. Fill in the Add Resource dialog
      • URL Path: /<Package>
      • Enabled: [Checked]
      • Access Policy: Path and all sub-paths
      • Description: OData service for <purpose>
    8. Click Save
      NOTE 1: When you specify Data Service URL = http://<HOST>:<PORT>/ in SAP Analytics Cloud, the SAPCP Cloud Connector will permit access to the /<Package> and all sub-paths on <Internal Host>:<Internal Port>.
      NOTE 2: Only a single OData service per connection can be consumed and you must provide the connection with a full OData service path per OData connection.
  2. For all other cloud OData services, use the OData service URL in SAC which is accessible from the internet.
    • NOTE: In case you have exposed the on-premise OData datasource externally, the checkbox "Connect to an On-Premise OData service" must be left empty. Since the service URL is accessible externally on internet it can be considered as a Cloud datasource from SAC perspective. Otherwise you will need to expose the service per steps in paragraph "A" and mark this checkbox.
  3. For exporting data via OData, See 2920775 - Export of SAP Analytics Cloud (SAC) transaction data to SAP BW/4HANA 2.0 SP4 or SAP BW 750 Support Package 18 system using OData.

Cause

Resolution

  1. Unable to connect to OData Services with error: 503 There is no SAP Cloud Connector (SCC) connected to your subaccount. Requested opening of a tunnel for subaccount "<name of your subaccount>" and default SCC location ID, that is, empty string or simply not configured. Check the configuration on SCC and cloud side.. Check the connection details and user credentials then try again.

    • Reason: Subaccount not connected in SAP Cloud Connector.
    • Solution: Connect the subaccount of your tenant in the SAP Cloud Connector.

  2. Unable to connect to OData Services with error: Error sending request to proxy. Status: 403 Reason: Forbidden. Check the connection details and user credentials then try again.

      • Reason: Subaccount config not complete by Operations team.
      • Solution: Open case via the SAP for Me on the component: LOD-ANA-BI (SAP Analytics Cloud)

    1. Unable to connect to OData Services with error: 502 The requested URL could not be retrieved. Check the connection details and user credentials then try again.

      • Reason: [Connect to an On-Premise OData service] is not checked.
      • Solution: Check it.

    2. The user doesn't have permission to access the requested resource.

      • Reason: Data Service URL is not properly defined/mapping is not done properly.
      • Solution: Make sure you're connecting to the Virtual Host / Port and the path is defined correctly, e.g. if the OData Service URL is in the format http://ODATAServiceName:Port/Package/ODataService, you will need to set the Path to "/Package"
      • More information in article 2739706.

    3. The request is unauthorized, please check data service url and credentials.

      • Reason: Credentials (user ID or Password) are incorrect.
      • Solution: Perform a test by navigating to the internal OData URL and make sure the credentials are correct and the OData entities can be listed.

    4. Unable to connect to OData Services with error: response status 404. Check the datasource URL and on-premise option then try again.

      • Reason: The URL path is not defined properly. Although UserName/Password works, there should be a missing directory/folder or something incorrectly defined in the URL itself after the host.
      • Solution: Make sure you're using the same format of the URL like the one you are accessing internally.

    5. Authentication is required. Please select one authentication type.

      • Reason: Self explaining, please select one auth. type.
      • Solution: Choose another authentication type (like: Basic Authentication).

    6. Unable to connect to OData Services with error: 503 Application Server Error. Check the connection details and user credentials then try again.

      • Reason: Error being raised by the HANA WebDispatcher handling HTTP(S) requests.
      • Solution: Open case via the SAP for Me to the HANA WebDispatcher team (Component/Expert Area: BC-CST-WDP) to troubleshoot further.

    7. If you are trying to consume an OData service from an SAC Analytics Designer application.

    See Also

    Your feedback is important to help us improve our knowledge base.

    Keywords

    EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, OData, 403, On-Premise, premise, connector, hcc, scc, ODAta, HANA, URL, Service 503, 404, 403, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, hana, hcp, scp, odata OData service path per OData connection, single OData service per connection OData Service Can not be accessed via BW Live Connection , KBA , unable to connect to s4 , odata connection to bw issue , odata connectivity sac help , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , 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