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
- SAP HANA Smart Data Integration
- 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.
SAP Knowledge Base Article - Preview