SAP Knowledge Base Article - Public

3517950 - Unable to Retrieve certain Navigation properties in ODATA Connections

Symptom

  1. Dataflow using depth 2 in ODATA properties shows warning message "The dataset's navigation properties include more than one collection. To avoid dataflow failure, retain columns from just one collection and delete the rest. "
  2. When running the Dataflow the error shows up as "Group messages:Group: default: Messages: Graph failure: producer1 failed with the following error. Querying multiple collection navigation properties is not supported."

Environment

SAP Datasphere

Cause

Datasphere has a restriction where navigation properties with collection entities are not supported. Check point 8 in Data Flow Add a Source

Resolution

Level 2 means adding navigation properties. Relationships from one entity to another are represented as navigation properties. Navigation properties are generally defined as part of an entity type, but can also appear on entity instances as undeclared dynamic navigation properties. Each relationship has a cardinality. Such Property can be single-valued or collection-valued navigation property. The limitation means if the navigation property is collection-valued,  it can only come from one collection. As a workaround each entity can be loaded separately and then build relationships in Datasphere/HANA.  

See Also

Generic ODATA connection

Keywords

navigation properties, collections, graph failure, ODATA, level 2 ,The dataset's navigation properties include more than one collection , KBA , DS-DI-DF , Data Flows , DS-BB-ODATA , To address issues related to Odata consumption API , Problem

Product

SAP Datasphere 1.0