SAP-samples / data-warehouse-cloud-connectors

Connecting third party clients to SAP Data Warehouse Cloud.
Apache License 2.0
11 stars 4 forks source link

Version 1.50 - InvalidEnumMemberPath - /MultiValue #10

Closed jongooding19 closed 11 months ago

jongooding19 commented 1 year ago

There is 2 connections in this version. The Catalog connection works The data connection gives the error: Details: "OData: The feed's metadata document appears to be invalid. Error: The metadata document could not be read from the message content. InvalidEnumMemberPath : 'Collection(Capabilities.FilterExpressionRestrictionType)/MultiValue' is not a valid enum member path. : (96, 14) "

OlafFischer commented 1 year ago

Hi Jared,

The odata response of datasphere contains mainly two parts: the real data and the metadata describing the real data.

For sure, PowerBi reads the metadata part and parses it to understand data types etc. Now it seems that the metadata provided by datasphere seems to be incorrect from PowerBi perspective. Now the question is: who is right? A typical one if you write connectors between two products 😊.

What I would recommend narrowing down the root cause:

Getting the facts:

Capture the Request and Response. This could be done using fiddler or another http sniffer or as an alternative, build the URL for your service request manually and let the browser call the API.

In the beginning of the response, you see a URL pointing to the metadata. Open and download it. In fiddler you see the request for metadata already and you can pick it from there.

Narrow down the root cause:

Best regards, Olaf

andrewzdyer commented 1 year ago

Hi Olaf I'm having the same problem. I can't install fiddler on my corporate PC, so I used Postman to get the metadata o the service. The annotation causing the error seems to be at the entity set not at the attribute level. The annotation looks like: `

` I can't see anything in Datasphere that might control this. Any thoughts!
OlafFischer commented 1 year ago

Hi Andrewzdyer,

please check out the latest comment on issue #12 - in addition, could you please share the annotation sample you found? In your last reply, you write "The annonation looks like:" - but unfortunately not followed by a sample.

Thanks, Olaf

andrewzdyer commented 1 year ago

Thanks Olaf. I forgot to add the annotation text as code. I have edited the last comment to fix this :)

Based on your comment in issue 12, I'll have a look at the view settings in Datasphere to see where a filter may be set. It doesn't appear to be on a field, rather on the entity. If I find config to update in Datasphere to update I will post.