Loading

CRM Analytics dataflow fails with "Can't propagate sharing rules"

Fecha de publicación: Jul 17, 2023
Descripción
A dataflow job can fail with an error message similar to the following:

"Something went wrong while executing the <Augment Name> node: Can't propagate sharing rules through the augment node <Augment Name> because both <Object 1> and <Object 2> contain <Object 1> sharing rules. Remove <Object 1> as the sharing source in the register node."

"Something went wrong while executing the <Append Name> node: Can't propagate sharing rules through the append node append because input nodes have different sharing-rule fields. Remove <Object Name> as the sharing source in the register node."

"Something went wrong while executing the Augment_Accounts_With_Opportunities node: Can't propagate sharing rules through the augment node Augment_Accounts_With_Opportunities because the node operation is set to LookupMultiValue and right select contains at least one sharing source."

The errors will occur when the below conditions are met:
  • An sfdcDigest node is used on an object that is supported for sharing inheritance
  • An augment or append transformation is created such that the left and right sources contain the sfdcDigest node in their lineages, or an augment transformation with a "Look Up Multiple Values" operation (LookupMultiValue) is created such that the affected object is in the right source's lineage
  • A dataset created via the above transformation is registered, and the affected object is defined as the Sharing Source
Solución
There are several paths to resolving the error message:
  1. Redesign the dataflow so that the object used for the Sharing Source is not digested through both sources in the transformation, or the Sharing Source is not digested through the right source of a LookupMultiValue augment
  2. Remove the object as a Sharing Source from the register node and use a Security Predicate for row-level security, then edit the target dataset to make sure these values match. If the dataset and dataflow do not match, subsequent dataflow runs will complete successfully with a warning message
Número del artículo de conocimiento

000380839

 
Cargando
Salesforce Help | Article