Analytics - Recipe fails with "failed to create KeyValueType list" or "context cancelled" error
Last updated 2020-07-28 ·Reference W-7688733 ·Reported By 3 users
A known issue is causing Recipes to fail to run with a message like the following:
DataflowInstance [03C...] cancelled. Something went wrong while executing the ConvertToEdgemart node: failed to create KeyValueType list: schema (JSON) contains 2 'dataset.field_name' fields
This may also manifest with an error like this:
DataflowInstance [03C...] cancelled. Something went wrong while executing the ConvertToEdgemart node: context cancelled
This occurs if the recipe contains two or more joins with datasets that have the same initial part of the name with different capitalization and include fields that are named the same.
Base Dataset - Opportunities
Joined Dataset - Sales_Data_Examples
Joined Dataset - sales_data_user_specifics
Both joined datasets contain an "Id" field that is added to the recipe.
When run, this recipe will fail with the following:
failed to create KeyValueType list: schema (JSON) contains 2 'sales_d.id' fields
This occurs due to a conflict in case sensitivity handling within Recipes.
Create two datasets with case-insensitive non-unique initial strings as names that include identically named fields.
Join both datasets to a base dataset in a Recipe.
Run the recipe, note the error.
Recreating the joined datasets with case-insensitive unique initial strings is a workaround, though this will impact existing dashboards and other references to those existing datasets.
For the above example, this could look like the following:
"Sales_Data_Examples" becomes "Examples_Sales_Data"
"sales_data_user_specifics" becomes "User_Specifics_ Sales_Data"
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.