The Salesforce workflow processes do not trigger on inserting new records

  • 37Views
  • Last Post 02 October 2018
  • Topic Is Solved
0
votes
OWOX Analytics posted this 01 October 2018

Hi Skyvia,

The Salesforce workflow processes do not trigger on inserting new records in case when at least one record from bulk has an error.

Task configuration: source - BigQuery, target - Salesforce

Package: 49367

Steps to reproduce:

1. Create a BigQuery table with two rows that contain conditions to run the automated process.

2. The first row should contain a valid record

3. The second row should contain the record which cannot be imported to Salesforce (duplicate, validation rule etc)

4. Add this table to Source

5. Configure the target object

6. Run the task

7. The launched task state should be - Failed. Result - 1 success row, 1 error row.

Expected result: At Salesforce created 1 record, the automated process is launched

Actual result: At the Salesforce created 1 record, the automated process is NOT launched

Please help with it. It's critical for us because this issue is affecting many configured processes. 

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 02 October 2018

We have tested simple example of trigger (before insert), such as:

trigger TestTrigger on MariaTest2__c (before insert) {
for(MariaTest2__c a : Trigger.New) {
        a.Description__c = 'New description';
    }  
}

Our Import package inserts two records to MariaTest2__c table (1 correct record and 1 incorrect). This scenario works as expected - 1 record is inserted with the updated description and 1 record if failed. Please specify what type of trigger do you use - before insert or after insert? If possible, please give us definition of your trigger, so that we are able to reproduce this case. 

 

Looking forward to your reply.

0
votes
OWOX Analytics posted this 02 October 2018

Maria, you are right, inserting works as expected.

The issue is not about inserting.

We have a many processes configured for new records (lead, account etc) with Process Builder, they should start when new record is created.

This processes work great when the import task returns a result "X  success row, 0 error row", but when result is "X  success row, X error row" they do not launch.

BUT, while I writting to you an explanation I found the reason of this issue by myself

In Process configuration must be enabled option "Recursion - Allow process to evaluate a record multiple times in a single transaction?"

So you can mark this ticket  as Resolved.

Thank you.

P.S. Could you give me an aswer on another one my ticket?

0
votes
Mariia Zaharova posted this 02 October 2018

P.S. Could you give me an aswer on another one my ticket?

Sure, I will review it and reply you back as soon as possible.

Close