SYS_FORMS3, SYS_COMMENTS and SYS_REPORTS were among the corrupted tables. Replacing the RX1 file with a clean one may help. The challenge is to not lose all Friday's work.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: karentellef via RBASE-L [mailto:[email protected]] Sent: Saturday, July 15, 2017 9:27 AM To: [email protected] Subject: Re: [RBASE-L] - RE: CORRUPTED DB Is it possible that your sys_forms3 table is the cause of the problem? If so, try deleting all the forms in your database, do another unload. Then simply bring in fresh sys_forms3 data from a backup copy from before you had the issues. All you would have to do is figure out if you made any form changes Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Fri, Jul 14, 2017 4:44 pm Subject: [RBASE-L] - RE: CORRUPTED DB Thanks, Dan. Will try later when all are gone. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Dan Goldberg Sent: Friday, July 14, 2017 4:43 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - RE: CORRUPTED DB I would try the rb1 file from last night and rbsync. See if that gets your closer to error free. Dan Goldberg From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, July 14, 2017 2:41 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - RE: CORRUPTED DB Dan, So if I use the RB1 file from a previous backup (I did an unload reload last night and all was good) would I also do the individual tables? Or try the RB1 file, RBSYNC first then if that does not work go with the unloading of individual tables? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Friday, July 14, 2017 4:39 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - RE: CORRUPTED DB Sometimes you can unload individual tables from the db explorer to minimize your loss. You might try to use the rx1 file from the last good backup and then use the current files. Make a backup first! You will need to rbsync them. Dan Goldberg From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, July 14, 2017 2:34 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - CORRUPTED DB Well I found that the DB is very corrupted. I checked it with RSCOPE and it found 35 errors in the structure. The DATA has over 7000 errors. When I tried doing an unload all then used the RUN command it stopped right away on a SYS_FORMS table. What options would I have now? I have a backup from last night but that means redoing everything today. Is that my only option? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- 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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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.
