SAP Knowledge Base Article - Preview

3043403 - SDI Excel Adapter Sharepoint 365 Error: AccessDeniedError Message: Either scp roles claim need to be present in the token.Get

Symptom

  • Load data from an Excel file in Sharepoint 365 with SDI seeing this error:
    AccessDeniedError Message: Either scp roles claim need to be present in the token.Get
  • Frame work Log shows:
    2021-03-31 09:36:22,753 [INFO ] DPFramework | AdapterManager.terminateSessionSync  - Closing session [xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]
    2021-03-31 09:36:22,753 [INFO ] ExcelAdapter | ExcelAdapter.close  - [48][xxxxxxxxxxxxxxxx]----------Close Connection------------
    2021-03-31 09:36:22,753 [INFO ] ExcelAdapter | ExcelAdapter.close  - Close: close current remote source / filesource.close()
    2021-03-31 09:36:22,753 [ERROR] DPFramework | WorkerThread.processRequest  - com.sap.hana.dp.adapter.sdk.AdapterException: Error code: AccessDenied
                                    Error message: Either scp or roles claim need to be present in the token.
                                    GET https://graph.microsoft.com/v1.0/sites/xxxxxxxxxxx:/sites/sdi_test:
                                    SdkVersion : graph-java/v1.5.0
                                    Authorization : Bearer < Token >
                                   403 : Forbidden
                                    Transfer-Encoding : chunked


Read more...

Environment

  • SDI DP Agent is 2.4.2.5. 
  • sharepoint
  • Excel  adapter
  • Microsoft Azure

Product

SAP HANA smart data integration 2.0 ; SAP HANA, platform edition 2.0

Keywords

Azure Sharepoint AccessDeniedError  roles , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

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

Search for additional results

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