10-22-2009 01:36 PM
We are on 7.2.2 LAN. This seems to be odd to me. It seems that most records that are sent back and forth to any database have their modifydate updated as part of the sync record. For example, I update a record in our Remote Office database at 12:00pm. At 12:14 pm, the sync runs to our Host database. When I check the Modify date of the same record on the host, it now says 12:14pm. It doesn't matter if the record is updated on the host, Remote Office, or another remote databas, whichever database recieves the change updates the record's modifydate in recieving database to be the time it is processed by the incoming sync process. The change to the modifydate is not sent back out ( I shiver to think of that loop!!) . I'll have 3 different modifydate values between a remote database, the Remote Office db, and the host db. Seems to me they should all be the same. All record types are effected. We are having some intermittent sync issues and think this may be contributing to it.
Any idea what would be causing this?
Solved! Go to Solution.
10-23-2009 11:45 AM
Well, Sage SLX front line supports says that updating the modifydate of a record to the time it was processed by the sync from the remote database is normal. They also mentioned that this is why using the Merge functionality can be dangerous. Anyone from Sage out there back that? I don't know, this just rubs me the wrong way. Comparing the same record in two different databases gets very difficult if you can't compare modifydates. I am sure someone out there can explain to me why this is a grand idea though.... I must just be missing the plot.
10-26-2009 09:17 AM
Pretty quiet out there.... So, can anyone confirm that on their version of SLX you see different modifydate values for the same record on the host, Remote Office, and/or other Remote database?
10-26-2009 05:10 PM
We are working to resolve this in the provider for default values, so they are included in the log transactions.
Paul ZeimetSalesLogix Development Mgr.