Edit Conflict on Random Product Bundles

Hi all.

I am having an issue within Quotes where seemingly randomly products added to a bundle cannot be saved via in quote save (Blue tick).

The error from the logs are: Edit conflict - client TS is 2021-12-16T12:02:13+00:00, server TS is 2021-12-16T12:02:23+00:00. However only some of the Bundles per Quote are affected, not all which is the baffling part for me.

If I move the products out of the broken bundle and into a new one, it works fine. And if I edit the products via the products module it also works fine. So it's a tad confusing at the moment.

I've disabled all logic hooks I can and the issue remains. From the Console in Chrome I am getting:

rest/v11_8/ProductBundles/ee57efd4-5133-11ec-861b-00163e2e3fe7/link/products/f3e5e9b0-5133-11ec-a3f6-00163e2e3fe7?erased_fields=true 409 (Conflict)

Any ideas?

Thanks!

0 Junaid Usman over 3 years ago

Daniel Hill

We are also having the same problem with one of our clients but in Opportunities. Looks like a Sugar bug or server time out of sync, as it starts appearing in 11.2 in my case. I did the initial investigation but have to leave it in the middle but as per my investigations, when I am saving a record around the last few seconds of a minute this error pops up. For me, it's hardly a 1-second difference between server and local time but in your case, it's around 10 seconds. This is significant.

Maybe check your server time settings and make sure that they are not ahead due to any reason because sometimes I have seen that the server time is even 5 minutes ahead of the normal local machine or global clock time.

Kind Regards,

Junaid
0 Francesca Shiekh 12 days ago

Daniel Hill , Junaid Usman did either of you figure out why these conflicts are happening?

I have the same seemingly random issue on a custom module when updating records in a subpanel. (Enterprise v14.0.0 on Site)
In addition to that the Conflict resolution screen won't load because the _onSaveError function in

clients/base/fields/editablelistbutton/editablelistbutton.js

is not getting a model, the model is undefined, so all I get is a blank page and a perennial "Saving" but the changes I made still actually save without me taking any further action other than reloading the record view of where I was when I made the change in the subpanel and verifying my data was updated.

It's causing a lot of headaches for my users, and I'm not sure I understand the clock issue you describe.

Clocks on my appserver and DB server appear to be in sync, with the exception of RTC time on the application server. Is that the problem?

Local time: Wed 2025-04-09 16:42:47 CDT

Universal time: Wed 2025-04-09 21:42:47 UTC

RTC time: Wed 2025-04-09 21:42:48

Time zone: America/Chicago (CDT, -0500)

System clock synchronized: yes

NTP service: active

RTC in local TZ: no

Thanks,
FrancescaS

P.S.

digging further into the error the log shows that the client and server are off by much more than a second.

Wed Apr 9 17:18:06 2025 [208765][1][ERROR] An exception happened: (409: edit_conflict) Edit conflict - client TS is 2025-04-09T15:26:52-06:00, server TS is 2025-04-09T16:18:06-06:00

My own computer is on MDT but the corresponding UTC matches the UTC on the DB server to the second as far as I can tell.
The application server and DB server are located in CDT.