Jim, I had mentioned earlier that I would be suspicious of the computer, and as more info comes forth, I would have to agree with Dan. If the hard drive is older than 3 years, assuming a standard grade drive, it may be the culprit. Data corruption is often the first clue. The drive can be checked to see if it is developing bad clusters which would probably confirm the issue. I replace standard OEM drives with enterprise grade drives so one can get 5 years or so out of the drive.
Steve Original message From: "Dan Goldberg" <[email protected]> To: [email protected]; Dated: 8/1/2017 11:41:11 AM Subject: RE: [RBASE-L] - DB files seem to be lost Something wrong with that pc then for sure. I assume rbase is installed locally on that pc? Dan From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, August 1, 2017 8:40 AM To: [email protected] Subject: RE: [RBASE-L] - DB files seem to be lost I wish it was that simple. Somehow the RBG95 exe file got wiped out. So I cannot connect to any DB, not just the corrupted one. James Belisle Making Information Systems People Friendly Since 1990 From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, August 1, 2017 10:22 AM To: [email protected] Subject: RE: [RBASE-L] - DB files seem to be lost James I don’t think you would have to re-install R:Base. It maybe that the .rx1 (rb1) file is corrupt. If you have a good copy of the #1 file you could just try coping #1 file to replace the corrupted one. It goes without saying make sure you make a copy of the database and work on that one. You will have to do RBSYNC and then if able to connect do a reload. You will may get errors that row counts don’t match but that should be ok. Now on the reloaded database (assuming you were able to connect to start with) do a PACK. I use to run into that a lot when I was at Pitt, because of that I created a Windows Scheduled Task that would open R:Base and then connect to the database if everything appeared to be ok I would copy #1 file to a backup area that was which had a folder for each hour. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, August 1, 2017 8:52 AM To: [email protected] Subject: [RBASE-L] - DB files seem to be lost We still use 9.5. Those following the post know our company has had some problems with DB corruption due to our IT company doing patches on the sever during normal business hours. They claim to have fixed this problem. However this morning at 5:45 am (the same time period our last problem occurred) we had another crash. Our IT company has not responded yet but here is what I am asking from your collective experience. I checked the DB with RSCOPE and found the SYS_TABLES and SYS_COLUMNS views have been corrupted. Also I cannot even access RBASE at all. It is like the computer does not see the program files themselves. Windows comes up with the box saying I need to find another app to open the files. When looking on either my own computer C drive or the server drive the DB files no longer show the RBASE icon associated with either 9.5 or XE. So when the IT people finally get things fixed, do you think I will need to reinstall RBASE? Or do you think a server restart will do the trick. I am trying to think in advance so I am prepared. James Belisle Making Information Systems People Friendly Since 1990 -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
