Symptom
The following error message occurs in SAP Analytics Cloud (SAC):
-
{ "status": 500, "message": "Error executing the user/group operation." }
Environment
- SAP Analytics Cloud (Enterprise) 2021.12.0
- Postman
Reproducing the Issue
- Open the Authorization tab and select the type as Basic Auth.
- Create a POST request to the token URL to retrieve an Access Token.
- Create a GET request to <tenantURL>/api/v1/scim/Users/Groups and include the following headers:
- Access Token: Bearer<String>
- x-sap-sac-custom-auth: true
- x-csrf-token: fetch
- After trying to retrieve the list, the operation fails with the error response described in the symptom.
Cause
The OAuth Client purpose has been configured for the incorrect authorization flow.
Resolution
The Open Authorization (OAuth) standard involves the following three parties:
- Client Application
- Authorization Server
- Resource Owner
There are two authorization flows:
- Two Legged - Client Application and Authorization Server
- Three Legged - Client Application, Authorization Sever and Resource Owner
In SAP Analytics Cloud Administration Console (App Integration) there are two types of OAuth Client purposes you can create:
- API Access - Supported for Two Legged Authorization flows.
- Interactive Usage - Supported for Three Legged Authorization flows.
Resolution 1
Two legged
In your SAC tenant, go to System, Administration, App Integration. Scroll down to the OAuth Client and create/edit the OAuth Client with the purpose selected to API access.
Resolution 2
Three Legged
In Postman click on the Authorization tab and change the Authorization Type from Basic Auth to OAuth 2.0. Fill out all the fields and then scroll to the bottom and click the orange button called Get New Access Token. This will result in a pop up to your SAC tenant which you will then need to sign in to retrieve the access token.
You must generate the access token from the orange button described below instead of clicking the blue button called send next to the URL.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stoppedm api, scim, oauth , KBA , LOD-ANA-ADM , SAC Administration , Problem