Think of just one PC on a network with a bad NIC which takes hundreds of retries to successfully complete a single write to the server. When a user (at one of my customers) got on this PC, the entire network would slow down and my RBase application would invariably get out of sync. As always, "it must be the software." They finally did bring in someone who found the problem a few minutes.
Hardware/software- it's always the intermittent or "kinda working" component that's a killer.
Dennis
*****
At 04:58 PM 3/8/2005, you wrote:
Claudine,
I have never had a database go out of sync unless one of two things happened...
1) An abnormal exit such as a power loss, tripped over power cable, etc. or
network related exit such as switch problems or a cable coming unplugged.
2) VPN's might frequently cause sync problems. If you are running over a VPN, I have seen the files get a time stamp difference during normal exit. I believe the RB1 file gets closed last and sometimes a delay in the VPN seems to cause it to get a slightly later date stamp. I have one case where a database gets accessed via an ODBC connection over a VPN and I see the sync problem occasionally with no other apparent errors or problems.
So if you have anything running over a VPN, I would bet that may be where the problem lies. If not, then you probably have a bad network component somewhere.
-Bob
- -------------- Original message --------------
- > Both my databases are continually out of sync even though I have AUTOSYNC ON
- > in my rbase.dat file. I have reported this and have never had an explanation
- > as to why this happens. Several times a week, I unload and recreate both
- > db's so there is no corruption involved, I don't think.
- >
- > ________________________________________
- > From: [email protected] [ mailto:[email protected]] On Behalf Of Dennis Fleming
- > Sent: Tuesday, March 08, 2005 1:24 PM
- > To: RBG7-L Mailing List
- > Subject: [RBG7-L] - Re: rbsync
- >
- > I had a customer where they had some network NIC problems and eventually I
- > had the RBSYNC as AUTOSYNC ON in the RBase config file. It worked, but you
- > are probably masking a problem where one or more user updates are not
- > getting the four RBfiles updated and time stamped properly. I.e., you could
- > be overlooking database corruption.
- >
- > Dennis
- > *****
- >
- >
- > At 01:00 PM 3/8/2005, you wrote:
- >
- > Anyone,
- >
- > Where is the best place to put RBSYNC? Exiting or Connecting?
- >
- > Thanks.
- >
- > Deb Roepken
- > cmri
- > 631-587-1495
- >
- >
- >
- > Both my databases are continually out of sync even though I have AUTOSYNC ON
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
