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. > > > > >
