Symptom
- The following error occur 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
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.
>> Notice the below 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 following the steps mentioned in the KBA 3425004
See Also
- KBA: 3425004 - How-To Import/Acquire Data from a Non-English Sharepoint site
- SAP Note: 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
- KBA: 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
- KBA: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) , Problem