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
- 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.