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 for Me (Login required).

Search for additional results

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