SAP Knowledge Base Article - Public

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

Symptom

  • This KBA is about to summarize the most common error messages in SAP Analytics Cloud while connecting to OData Services.
  • You've followed the steps to set up OData Service URL and Import Data connection as per Import Data Connection to OData Services
  • However some of the error messages are being encountered while connecting to OData Services in SAP Analytics Cloud:
    1. Error: "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."
    2. Error: "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."
    3. Error: "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."
    4. Error: "The user doesn't have permission to access the requested resource."
    5. Error: "The request is unauthorized, please check data service url and credentials."
    6. Error: "Unable to connect to OData Services with error: response status 404. Check the datasource URL and on-premise option then try again."
    7. Error: "Authentication is required. Please select one authentication type."
    8. Error: "Unable to connect to OData Services with error: 503 Application Server Error. Check the connection details and user credentials then try again."

Environment

  • SAP Analytics Cloud 2018

Reproducing the Issue

Follow the steps as outlined in Import Data Connection to OData Services

  1. For on-premise OData service host http://<HOST>:<PORT>/<Package>/<Service> create SAP Cloud Connector mapping entry as described below

    1. In SAP Cloud Connector in the 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
    5. Now when you specify Data Service URL = http://<HOST>:<PORT>/<Package>/<Service> in SAP Analytics Cloud it will use SAP Cloud Connector to look up <HOST>:<PORT> under <Virtual Host>:<Virtual Port> and route the request to <Internal Host>:<Internal Port>
    6. Select the system you added to the Mapping Virtual To Internal System list
    7. In the Resources Accessible area, select + (Add)
    8. Fill in the Add Resource dialog
      • URL Path: /<Package>
      • Enabled: [Checked]
      • Access Policy: Path and all sub-paths
      • Description: OData service for <purpose>
    9. Click Save
    10. Now when you specify Data Service URL = http://<HOST>:<PORT>/<Package>/<Service> in SAP Analytics Cloud SAP Cloud Connector will permit access to /<Package> and all sub-paths on <Internal Host>:<Internal Port>
  2. For Cloud OData sources you can use the OData Service URL in SAC which is accessible from the internet

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 Incident via the SAP ONE Support Launchpad 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 Virtual Host/ Port and the path defined correctly.
    3. The request is unauthorized, please check data service url and credentials.

      • Reason: Credentials (User Name 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 Incident via the SAP ONE Support Launchpad to the HANA WebDispatcher team (Component/Expert Area: BC-CST-WDP) to troubleshoot further.

    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, 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 , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

    Product

    SAP Analytics Cloud 1.0