SAP Knowledge Base Article - Public

3253981 - Error:"An error occurred while parsing service metadata: undefined" occurs when creating a model from a SharePoint Data Source in SAC

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

SAP Analytics Cloud

Reproducing the Issue

  1. Create an Import Connection to SharePoint by Open Connectors.
  2. Go to Modeler and choose Create New model From a Data Source.
  3. Select Open Connector under Categories and SharePoint as a Data Source.
  4. 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

Keywords

SAC, SAP Analytics Cloud, SharePoint, Open Connectors, Model, Data Source, Connection, Error. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0