Symptom
- 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. "
- 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
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