SAP Knowledge Base Article - Public

3806430 - Error "Invalid odata connection! Invalid useruuid" when validating SAP SuccessFactors Connections in Datasphere

Symptom

When validating the SAP SuccessFactors connection in Datasphere, below error message is displayed:

-----------------------------------------------------------------------------------------------

Connection "XXXX" couldn’t be established. 
- Data flows can’t be used because of errors in the connection.
- Replication flows are not supported.
- Remote tables can’t be used because of errors in the connection.

Data Flows: Cause: Invalid odata connection! Getting odata metadata failed because of org.apache.olingo.client.core.http.OAuth2Exception: Failed to fetch OAuth2 token! Token endpoint response HTTP/1.1 401 {"errorHttpCode":"401","errorMessage":"Invalid useruuid"}

Remote Tables: Unable to connect remote source: DPAdapterAccess::Connect:exception 2520214: Failed to fetch OAuth2 access token: 'HttpClient.request: OAuth2 request failed with error:
Response HTTP code: 401
Response HTTP body: {"errorHttpCode":"401","errorMessage":"Invalid useruuid"}'
(adapter type: ODataAdapter, source name: DWC_<space_name>.<connection_name>), Code: 5921, SQL State: HY000
-----------------------------------------------------------------------------------------------

When configuring the connection, select the "OAuth 2.0" for Authentication Type and set the Configure Identity Provider to "true".

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

SAP Datasphere

Reproducing the Issue

Validate the SuccessFactors connection

Cause

The Login Name configured in the user details in SAP Cloud Identity Services user management doesn't match the user name entered in the USERNAME field for the SAP SuccessFactors user.

Resolution

Please refer to Configuring Dynamic Generation of SAML Assertions for SAP SuccessFactors Connections | SAP Help Portal

  1. Ensure the user exists in both SAP Cloud Identity Services and SAP SuccessFactors.
  2. In SAP Cloud Identity Services user management, set the Login Name to exactly match the user name entered in the USERNAME field of the SAP SuccessFactors user. 

See Also

Keywords

SuccessFactors, OAuth, SAML, Dynamic Generation of SAML Assertions, useruuid , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions

Attachments

Pasted image.png