Skip to main content
Answer

Another process has updated the 'SOOrder' record. Your changes will be lost.

  • August 30, 2023
  • 4 replies
  • 1493 views

We’re in the beginning stages of testing order imports from Our test Shopify environment to Acumatica. 
When attempting to import new orders we’ve started to see an error message when going to Process Data, after the Sales Order has been prepared.: 


“Another process has updated the 'SOOrder' record. Your changes will be lost.”

We haven’t made any changes to the orders that fail versus the orders that don’t fail, and we haven't been able to identify a trend. 

Any ideas on how to resolve this error so that we can have all orders import properly? 


 

Best answer by sweta68

Hi @tmsharp ,

This error often indicates a concurrency issue, meaning that another user or process is modifying the same sales order at the same time. Check if there are multiple users or integrations working with these sales orders simultaneously.

 Ensure that the order of operations in your integration process is correct. For example, if multiple API requests are made to update the same sales order, the timing and order of these requests might cause conflicts.

Hope, it helps!

Regards,

Sweta

4 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • August 31, 2023

Strange one have you checked if you have any Business Events running that are updating the Sales Order. You could after you get the error on the Sales Order. Open it and click on Tools>Audit History and it will tell you which user/form last modified it might help find the cause

 


Forum|alt.badge.img+9
  • Semi-Pro III
  • Answer
  • September 6, 2023

Hi @tmsharp ,

This error often indicates a concurrency issue, meaning that another user or process is modifying the same sales order at the same time. Check if there are multiple users or integrations working with these sales orders simultaneously.

 Ensure that the order of operations in your integration process is correct. For example, if multiple API requests are made to update the same sales order, the timing and order of these requests might cause conflicts.

Hope, it helps!

Regards,

Sweta


darylbowman
Captain II
Forum|alt.badge.img+15

Also make sure no business events are running.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • September 13, 2023

@tmsharp yes, this concurrency issue. But, most of the times this cause from our code due to the dirty caches. Please check the cache updates properly and modify your code accordingly.