Hi All.

I am currently experiencing the unable to lock row error on 2 scheduled flows that I have created. I am still pretty new to flows and learning as I go so any help with this would be appreciated

Basically these 2 flows are updating the opportunity records that meet set criteria and amending a checkbox value.

I have tried to capture the flows below:-


The second flow works in pretty much the same way but does not have a decision element included.

I have tried to simplify the flows as much as I can and spread the schedule out to avoid overlap with one starting at 2am and the other at 4:30am

I receive a number of error emails on both flows.

An example of the error email I get is:-

Error element Update_Retention_Flag (FlowRecordUpdate).
The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records:

Any help of guidance for how I can resolve this would be much appreciated as I am sure there is something basic that I am missing or I have just gone about this the wrong way.

Thanks


 

Hi All. Apologies if this is something that is actually really straight forward but I can't quite get my head around it...

I have 4 currency fields in my opportunities and 4 corresponding checkboxes. What I am trying to do is create a formula where the values are in the 4 currency fields are totalled based on which checkboxes are ticked.

In this example there are 3 values populated but only 2 checkboxes ticked so the total I need to get to is £598.00



If anyone can assist with this i'd really appreciate it.

Thanks

Hi All.

I am currently experiencing the unable to lock row error on 2 scheduled flows that I have created. I am still pretty new to flows and learning as I go so any help with this would be appreciated

Basically these 2 flows are updating the opportunity records that meet set criteria and amending a checkbox value.

I have tried to capture the flows below:-


The second flow works in pretty much the same way but does not have a decision element included.

I have tried to simplify the flows as much as I can and spread the schedule out to avoid overlap with one starting at 2am and the other at 4:30am

I receive a number of error emails on both flows.

An example of the error email I get is:-

Error element Update_Retention_Flag (FlowRecordUpdate).
The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records: 0014J00000XrbPeQAJ,0014J00000T2YJ6QAN,0014J00000Z6h1hQAB,0014J00000XrivzQAB,0014J00000PRM95QAH,0014J00000XrhbeQAB,0011t00000MwjhqAAB,0014J00000TW8gwQAD,0014J00000WmNaiQAF,0014J00000WliUdQAJ, ... (65 more). You can look up ExceptionCode values in the SOAP API Developer Guide (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_concepts_core_data_objects.htm" style="color:blue; text-decoration:underline).---The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 75 records:

Any help of guidance for how I can resolve this would be much appreciated as I am sure there is something basic that I am missing or I have just gone about this the wrong way.

Thanks


 

Hi All. Apologies if this is something that is actually really straight forward but I can't quite get my head around it...

I have 4 currency fields in my opportunities and 4 corresponding checkboxes. What I am trying to do is create a formula where the values are in the 4 currency fields are totalled based on which checkboxes are ticked.

In this example there are 3 values populated but only 2 checkboxes ticked so the total I need to get to is £598.00



If anyone can assist with this i'd really appreciate it.

Thanks