SAP Knowledge Base Article - Public

3308302 - Failed to import data from Datasphere OData API into SAC because of an error in the plugin service

Symptom

The import job fails when loading data from SAP Datasphere (DS) into SAP Analytics Cloud (SAC) via OData API:
QueryName has failed to upload because of an error in the plugin service

Environment

  • SAP Analytics Cloud
  • SAP Datasphere

Reproducing the Issue

  1. Configure DWC Odata API connection as per blog:
    Using the Data Warehouse Cloud OData API with SAP Analytics Cloud | SAP Blogs 
  2. Create a new model on the Odata connection
  3. Select Query and select objects
  4. Click Create
  5. Draft data load failed with error:
    QueryName has failed to upload because of an error in the plugin service

Cause

Some dimension names have double-byte characters.

This can be checked when creating model in SAC,
on Build Odata Services Query page, show technical name for Available Data,
See some objects name includes double bytes characters.

Resolution

Change any double-bytes characters to English.

Keywords

Chinses, Japanese, failed, cannot, draft, model, api, odata, dwc, sac , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud all versions