Claudine,
I don't think it is unusual for the RB4 file to not have the same operating system timestamp as the other files. It may only get updated when data gets written to it, or when someone DISCONNECTs or EXITs the database.
What is important is the internal timestamps that R:Base maintains in the four files. But now that I've written that, I'm asking myself how the internal timestamp in RB4 can disagree with the others if its operating system timestamp is different. All I can tell you is that I've observed this condition in the production environment and the system is working fine with 20-30 users attached, and no error is reported when I CONNECT myself.
Bob,
That's very interesting. When I work from home I am on VPN but here in the office, I'm simply on the network. RB4 seems to be the file most often out of sync. What should I ask my hardware guys to check??
Claudine
________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 3:59 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: rbsync
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 > > >
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
