Thank you Karen!
Indeed if I DEL ROWS from the SYS_FORMS3 table first, I am able to reload the good rows backed up with UNLOAD ALL FROM SYS_FORMS3! However, that does not bring the db back to a working state. Thank you Gary! You asked if a backup is involved and you may be spot on there. Perhaps the problem lies with a named drive on the server in my backup routine. I'll change that to UNC. Thanks for all your help. Claudine _____ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, May 04, 2010 11:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: V8 Disappearing Form Table/View Connections Hi Claudine! I cannot comment on why it happened; I've never seen this. The 2 error messages you're getting are normal because the "unload all" will attempt to drop the sys_forms3 table (not allowed) and then do a "create schema database", so you're right in that you can just ignore those 2. Because it couldn't delete the sys_forms3 table, your original corrupted data is still in there, and it would have loaded a second copy. I wouldn't do an "unload all" but rather a "unload data", and delete rows from sys_forms3 before bringing in the file. When you did the delete duplicates, you wouldn't know whether it deleted the corrupted rows or the good ones.... It looks like it deleted the good rows. So do a delete rows first. Karen I am hoping that someone has experienced this and can shed some light on why this has happened and maybe how to resolve it. This is the second time this has happened to me. Both times, I recovered the database forms (listing) by restoring a previous backup. Out of the blue, in R:BASE Explorer, Forms tab, the form names are listed but the Table/View and Form Description columns are blank. When starting the database, an error message warns the user that the main form cannot be loaded. Same error when I try to DESIGN the form. The form is based on FormTable which exists and has only one row. An UNLOAD ALL backup yields a very small file 35 K and no LOB! Upon close inspection, the SYS_FORMS3 has all the forms with their respective table/view, a description and the LOB data INTACT. Thinking that I could UNLOAD the sys_forms3 data, delete the sys_forms3 table and reload it from the backup, this is what I did and the resulting errors. SET NULL -0- OUTPUT SYSFORMS3.DTA UNLOAD ALL FROM SYS_FORMS3 OUT SCREEN RUN SYSFORMS3.DTA -ERROR- You cannot delete a system table. ( 10) -ERROR- Duplicate database name ( 720) Database Exists -ERROR- Illegal table name - SYS_FORMS3 (2037) Begin R:BASE Data Loading for SYS_FORMS3 End R:BASE Data Loading Even with the errors, I ended up with TWO ROWS for each form, clearly visible in the R:BASE Explorer | Forms tab. DELETE DUPLICATES FROM SYS_FORMS3 USING SYS_FORM_NAME 136 row(s) have been deleted from SYS_FORMS3 I am returned to a Forms List with no Table/View or Form Description in R:BASE Explorer.
