Reply
 
LinkBack Thread Tools Display Modes
Old 08-05-2009, 01:58 AM   #1 (permalink)
Senior Member
 
Join Date: Jul 2008
Location: Olympia, WA
Posts: 342
grichards is a jewel in the roughgrichards is a jewel in the roughgrichards is a jewel in the roughgrichards is a jewel in the rough
Send a message via Skype™ to grichards
Default lan not-so-sync'd

Client A and Client B refer to 2 different machines running the SI 5.5 client software.

1) open a product through MMPD on Client A
2) edit Cost fields
3) save product
4) synchronize Client A
5) open same product through MMPD on Client B
6) edit Cost fields
7) save product
8) synchronize Client B

What i would expect to happen:
Client B shows the product in Conflict Resolution (because the product has changed since Client B's last sync).

what happens instead:
LanSync allows ClientB to write to server overwriting the change from ClientA
grichards is offline   Reply With Quote
Old 06-09-2010, 10:35 AM   #2 (permalink)
Super Moderator
 
NareshN's Avatar
 
Join Date: Nov 2006
Posts: 430
NareshN has a spectacular aura aboutNareshN has a spectacular aura aboutNareshN has a spectacular aura about
Default

Richards,

The issue here is how we define a conflict.

In our implementation we track the UTC time a record is updated and the one with the latest UTC time "wins".

A conflict happens if a record is uploaded to server and record exists on server with a UTCUpdateTime on server greater than record being uploaded.

So basically conflict can happen as follows -
1. User A updates Product A at 11AM but does not sync.
2. User B updates Product B at 11:15AM and syncs.
3. Server now has a record with Product A with update date time = 11:15AM (from User B)
4. User A syncs at 11:30AM - code finds a record for product A with update date time = 11:15. However User A has updated at 11AM - this triggers a conflict.

In the LANSync implemenation it is basically the UTCUpdateDateTime which trigers the conflict - it it is more than server record - server record gets updated or we get a conflict.
NareshN is offline   Reply With Quote
Old 06-14-2010, 06:01 PM   #3 (permalink)
Senior Member
 
Join Date: Jul 2008
Location: Olympia, WA
Posts: 342
grichards is a jewel in the roughgrichards is a jewel in the roughgrichards is a jewel in the roughgrichards is a jewel in the rough
Send a message via Skype™ to grichards
Default

NareshN,

to clarify, since its a delicate explanation and accuracy matters:
Originally Posted by NareshN View Post
...conflict can happen as follows -
1. User A updates Product A at 11AM but does not sync.
2. User B updates Product B at 11:15AM and syncs.
do you mean:
2. User B updates Product A at 11:15AM and syncs.

??

thanks for the explanation of how dTools defines conflicts: Latest data wins.
and thanks for your recent responses to a number of other items that i had posted about.
__________________
Systems Technician/Crestron Certified Programmer
www.ccisolutions.com
[SIGPIC][/SIGPIC]
grichards is offline   Reply With Quote
Old 06-15-2010, 05:14 AM   #4 (permalink)
Super Moderator
 
NareshN's Avatar
 
Join Date: Nov 2006
Posts: 430
NareshN has a spectacular aura aboutNareshN has a spectacular aura aboutNareshN has a spectacular aura about
Default

Richards,

You are right - it should be Product A.

Naresh
NareshN is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SI5 - Error en Lan Sync. Ramiro Colasurdo D-Tools en Espaņol 2 08-16-2007 01:13 PM


All times are GMT. The time now is 12:48 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.0
D-Tools, Inc.