Jim The RB1 file could be corrupt. This will happen especially if someone is trying to change the structure (add columns, rename columns or adding tables) while someone else is connected to the database.
Since you don't have R:Scope you could compare the size of your RB1 and RB3 files to the night before assuming you have a backup. If the number 1 file is different you could try replacing the #1 file from the previous day to the current. Next try the RBSYNC. The next step would be to reload the database and then pack the database. You may get errors that the pointers are wrong but it should be corrected in the reloaded database. You may want to attempt this on your local drive because it will allow the process to go faster. As you know make sure you make a copy of the database before trying anything. Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Tuesday, December 02, 2014 6:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBASE Jim, Look at the help for RBSYNC (<F1> from within R:Base and then find RBSYNC in the Index tab); it should give you the information needed to synchronize the date stamps for the database files and it might be able to rebuild the indices as well. R:Scope more than pays itself the fir time you use it. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, December 02, 2014 3:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBASE Javier, A couple of things: 1) How does one sync the database? When I tried the RBSYNC it told me a couple of errors but I could not fix it unless the RBSYNC does that for me. The errors had to do with error reading the index list and a columns index file is reference invalid. 2) I do not have RSCOPE so cannot do that. 3) We may end up with one lost day's work since this is the end of the day here. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Tuesday, December 02, 2014 3:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBASE Jim, Maybe you have a flaky hard disk on the server or the server itself? One think I always do when copying database files is to make sure no one is logged in; in fact, I am thinking that you should get an error along of the lines "the files is in use..." and will not allow you to copy it. This is what I would suggest: Do not use the database until the issues have been resolved or you might end up with more corrupted data. Have everybody logout from the system. Copy the database files to your remote computer to eliminate network/transmission issues and work directly on the local computer. Sync the database files if they are not synchronized. If you still cannot access it user R:Scope to check the files. If you cannot fix the issue, restore the database from you last know good backup...hopefully the previous night. I ran into a similar issue a while back when a server hard disk started to go bad. We did a complete check of the server, replaced the hard drive and restored the database files from the previous night backup; luckily (?) it happened early in the morning so we only lost about 1 hour of light data entry. A royal PIA to say the least, but catching it early helps. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, December 02, 2014 1:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBASE Javier, When this first started today, I was the only one having the problem. Just in the past few minutes, maybe 30, I found out the office people are starting to have strange behaviors as well with RBASE. Some got out completely from RBASE and could not get back in. Then a few minutes later they were allowed access with no problem. I even was able to connect for a little while just a few minutes ago, but once I got out I could not get back in. I got the same error of files being out of sync and out of Internal memory. The number of users should not be a problem since we have the compiler. I will answer some of your questions. The DB is on the server and everyone accesses the DB with a compiled application. I am the only one who has a full version of RBASE 9.5 on my computer since I need that to update and change things. I access my computer (this is a dedicated computer set aside for me) remotely through a VPN setup. I copied the running DB to my C drive on my computer at the office not here at the house. Even on my C drive I get the INTERNAL ERROR - out of dynamic space. Database files are out of sync. When copying the files I did as suggested by Paul and went to a separate file folder first then copied from there to my C drive. By the way, the time stamp on the files are all different. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Tuesday, December 02, 2014 1:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBASE Jim, If I understand correctly. The server database can be accessed by everyone except by you (remotely), is this correct? Did you have the database copied from the server to your office workstation or to your remote computer? Were there users connected to the database at the time? You could try having everyone exit the database and copy the database files with no users connected; use RBAdmin to make sure no one is connected. How are you accessing the database remotely, VPN? RDP? Are you connecting directly to the server or to your office workstations? Are you using a compiled application or a full version of R:Base? If you are using a full version of R:Base, is this version installed at your office workstation or on the remote computer? Since other users can access the database, it would seem that the problem is either in your office workstation or the remote computer; hopefully with the information above we can figure out the issue and find a solution. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, December 02, 2014 1:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBASE Lena, Thanks for the suggestion. I did that and it said the DB files were in sync. But when I tried to connect, same error came up. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Lena Dammstrom Sent: Tuesday, December 02, 2014 11:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: errors What happens if you do a RBSYNC dbname EXECUTE to the DB on your C Drive? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, December 02, 2014 11:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: errors Here is some more information on the error situation I have. Interestingly it seems this error is not occurring at the office with the other employees. It seems I am the only one having this error. I took the same DB from the server drive and copied it to my C drive. I was unable to connect to it there either. Same error about being out of Dynamic space and files out of sync. I also had a fellow employee (after I had logged off my remote session) shut down my computer then reboot it. Same problem came up. Any suggestions? James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, December 02, 2014 10:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - errors Have not received the following error in years but it just popped up a few minutes ago. I was working on things just fine when this happened. Database files out of sync. Exception EaccessViotationin module KMMenu10.exe at 10133088 Access violation at address 10134088. Read of address 0880AC68. I am remotely connected. When this happened I logged out, disconnected the remote session then reconnected. Still the same problem. Any blues clues? James Belisle Making Information Systems People Friendly Since 1990
