SAP Knowledge Base Article - Public

2828688 - Unable to build model on any standard OData service through import data connection to SAP S/4HANA in SAP Analytics Cloud (SAC)

Symptom

  • Unable to build model with OData service through import data connection to SAP S/4HANA in SAP Analytics Cloud (SAC).
  • After selecting one entity, the query panel cannot be shown.
  • The following error message occurs in Chrome Development Tools:
    {"messageId":"AUTHENTICATION_ERROR","message":"Unable to connect to datasource. Check the connection details and user credentials, and then try again.","bUIMessage":false,"bWarning":false,"customData":"Authentication failure. Try authenticating again.(If this is using a shared connection without credentials, please enter the credentials by running a data import using such connection)","status":401}

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create one import data connection to SAP S/4HANA On Premise system.
  3. Try to create a new model on the connection and then choose one entity from any standard OData service exposed from the S/4HANA On Premise system.
    => The query panel cannot be shown and it is impossible to build model.

Cause

  • The standard OData service has fixed client (here, take 100 as example), which can be verified by:
    1. Log on to S/4HANA system.
    2. Run T-Code SICF and then enter Service Name to Execute.
    3. Double click the OData service from list and then switch to Logon Data tab.
      => If right-clicking the Odata service to select Test Service, it will open the OData service in browser with "?sap-client=100".
      => Without specifying client number in the URL, it works in the fixed client as above.
  • However, the S/4HANA user in the import data connection doesn't have access to client 100, so the user cannot access the Odata service with "?sap-client=100".
  • The user can only access the OData serivice from browser by specifying different sap-client in the URL.
  • But it is impossible to sepcify different sap-client for the individual OData service when creating model from SAC.
  • Even setting "?sap-client=<...>" in the Data Service URL of import data connection, it doesn't make help since anything following "?" is only used for authentication and will not affect queries.

Resolution

  • Change the client of those standard OData service to other client number, on which the S/4HANA user has access.
    OR
  • Use another S/4HANA user having access to client 100 in the import data connection.

See Also

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

Keywords

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, 401, S4, S4HANA, S/4HANA, AUTHENTICATION_ERROR, credentials, Authentication, client, sap-client , KBA , unable to connect to s4 , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0