I have Issue with Data Abstract in .NET: Synchronization Errors

Data Abstract
1

Hello guys! :smiling_face_with_three_hearts:

I am using Data Abstract in a.NET project, and I am running into some synchronization issues that I can’t figure out how to fix. In my configuration, the client updates and requests data from the server on a regular basis using a client-server architecture.

My particular issue is that occasionally, when several clients are submitting requests at once, the information that is returned appears to be out of sync. When Client A updates a record, for instance, Client B queries the same record nearly simultaneously and receives an old version of the information.

Here is the few things that was I tried:

  • There are no connectivity problems and that every client is successfully connected to the server.
  • Verified that updates are being committed to the database and that the server is responding to requests in the proper sequence.
  • investigated possible caching problems, however the issue remained after caching was turned off.

I also check this: https://talk.remobjects.com/t/error-connecting-to-firebird-dataabase-with-dataabstract-10-0-0-1521-netcorsalesforce-dev But I have not found any solution. Could anyone suggest me the best solution for this.

Thanks in advance! :innocent:

Respected community member :blush:

2

Would this not simply be “as expected”? Essentially, this is a race condition. Nothing ever happens truly “at the sometime”, really. If Client B’s request is processed slightly BEFORE the update from A, it gets the old data, if it gets processed AFTER, it will get the new data…