SAP Knowledge Base Article - Preview

3322974 - Accessing Database Explorer in HANA WebIDE via external IDP user ends with "Could not get the list of HDI containers."

Symptom

Followed KBA 
2569903 - How to configure SAML authentication on HANA XSA
to enable SAML Trust between HANA XSA and Identity Provider(IDP) such as SAP Identity Authentication Service(IAS) or 3rd party IDP such as AzureAD.

Database Explorer of HANA WebIDE ends with error:
--------------
Could not get the list of HDI containers.
"Request failed: Internal Server Error URI: /hrtt-service/sap/hana/cst/api/v2/databases/hdiServices()?threshold=500"
--------------
like following image:


If collect network trace can see following request end with 500
https://<FQDN>:<port>/hrtt-service/sap/hana/cst/api/v2/databases/hdiServices()?threshold=500
and the response content is:
--------------
{
    "error": {
        "errorCode": "XSA_REQUEST_ERROR",
        "message": {
            "value": "Error returned from controller API: User \"<userid>\" has no Controller role (Org{Manager,Auditor} or Space{Manager,Developer,Auditor}). Please assign a role with a privileged Controller user (e.g. use 'xs set-org-role' or 'xs set-space-role').",
            "lang": "en-US",
            "requestId": "5d61c498-f7fb-4ef3-a180-aa39c46070ca"
        },
        "args": [
            "User \"<userid>\" has no Controller role (Org{Manager,Auditor} or Space{Manager,Developer,Auditor}). Please assign a role with a privileged Controller user (e.g. use 'xs set-org-role' or 'xs set-space-role')."
        ],
        "innererror": {
            "code": 401
        }
    }
}
--------------

Have followed KBA:
2679770 - SAP Web IDE for HANA freezes in the loading screen - User has no Controller role
still not able to fix issue.

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


Read more...

Environment

  • SAP HANA Extended Application Services, Advanced Model - XSA
  • HANA WebIDE

Product

SAP HANA, platform edition all versions

Keywords

SSO user, single sign on, db, add database, web ide , KBA , HAN-WDE-DBX , Database Explorer in Web IDE for SAP HANA , HAN-WDE-PLF , SAP Web IDE for Hana platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.