Skip to content

Can child records with a self-lookup field be inserted in multiple jobs? #1084

@Stepan007

Description

@Stepan007

After reading this https://help.sfdmu.com/faq/sfdmu-data-insertion-and-limitations/can-child-records-with-a-self-lookup-field-be-inserted-in-a-single-job I know that child records with a self-lookup field can't be inserted in a single job but can they be inserted in a multiple ones?

If my understanding is correct it will always Insert all records with the self-reference field set to null. Unfortunately I'm using a managed package where there is a validation that parentId has to be populated so even if I split records into multiple jobs I get an error.

Here is an example:
First job:
Id,Name,pse__Parent_Region__c,pse__Parent_Region__r.Name
aDR0Y0000004R85WAE,Global,,

Second job:
First job:
Id,Name,pse__Parent_Region__c,pse__Parent_Region__r.Name
aDR0Y0000004R8AWAU,Europe,aDR0Y0000004R85WAE,Global

message: "Region requires a parent. There are too many top-level Regions in the system.: 2,,Europe"

Is there a way how can I skip the first insert with self-reference field set to null and insert it with already evaluated reference?

Thanks in advance!

Metadata

Metadata

Assignees

No one assigned

    Labels

    in-progressIssue is currently in the resolution progress

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions