Symptom
The following error occurs in SAP Analytics Cloud (SAC) when creating a model from SharePoint Data Source:
- An error occurred while parsing service metadata: undefined
In the browser developer tools HTTP archive (HAR) file trace:
- {"result":"{\"error\":{\"code\":\"ERROR_INVALID_METADATA\",\"rawError\":\"Failure in executing client request of connection type[[name\\u003d\\\"com.sap.orca.da.plugin.cloudelements.documents.sharepoint\\\", version\\u003d\\\"1.0\\\", patch number\\u003d\\\"0\\\"]]: An error occurred while fetching service metadata: Access was denied.\",\"params\":[]}}"}.
- {"result":"{\"error\":{\"code\":\"ERROR_INVALID_METADATA\",\"rawError\":\"Failure in executing client request of connection type[[name\\u003d\\\"com.sap.orca.da.plugin.cloudelements.documents.sharepoint\\\", version\\u003d\\\"1.0\\\", patch number\\u003d\\\"0\\\"]]: An error occurred while fetching service metadata: Not found\",\"params\":[]}}"}
Environment
SAP Analytics Cloud 2022.15.15
Reproducing the Issue
- Create an Import Connection to SharePoint by Open Connectors
- Go to Modeler and choose Create New model From a Data Source
- Select Open Connector under Categories and SharePoint as a Data Source
- Choose the connection created and click Next
Error: An error occurred while parsing service metadata: undefined
Cause
The issue occurs due to the Default Language and Display Language settings of the SharePoint site.
Resolution
- It is now possible to import/acquire data from a non-english sharepoint site. The instructions can be found in kbase 3425004
See Also
- 3113235 - Unable to acquire data and lack of a descriptive error message for SharePoint or OneDrive for Business in SAP Analytics Cloud caused by expired authentication
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
SAC, SAP Analytics Cloud, SharePoint, Open Connectors, Model, Data Source, Connection, Error. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Known Error
Product
SAP Analytics Cloud 1.0