OK, I've tried unloading the data for sys_layouts3 and reloading it. Reloads the error whatever it is...
I've tried removing the second record, unloading data and reloading it. No error in RScope but Access Violation in RBengine.dll still keeps me from using database (actually it lets me run one item on my main menu but when I return to run any other item, it bombs). I'm going to try restoring older (unload all) backups to see if I find one with no RScope error. Since I do such a backup everyday, it'll probably take a while... Maybe I'll try the oldest first... > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine > Robbins > Sent: Saturday, March 19, 2005 1:15 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Access Violation Messages and Sys_Layouts3 table > corruption > > Javier and Bernie, > > I have now reloaded the last 4 complete backup files created with unload > all > and every single one reports the 'data' error in RScope for the > sys_layouts3 > table. > > I also tried deleting both records in sys_layouts3 and RScope reports no > corruption. However, Access Violation messages continue and db is > unusable. > > (how do you spell seperately?) separately. And that's a good idea. I'm > going to do that now... > > Claudine > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier > > Valencia > > Sent: Saturday, March 19, 2005 1:03 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - RE: Access Violation Messages and Sys_Layouts3 table > > corruption > > > > You could try doing a RELOAD or an UNLOAD of the structure and data and > > then > > reconstructing the database. TTBOMK the SYS_LAYOUTS3 table stores only > the > > layouts of tables of views and it is not critical, if the data is > deleted > > it > > should just display the tables/views in the default format. > > Javier, > > > > Javier Valencia, PE > > President > > Valencia Technology Group, L.L.C. > > 14315 S. Twilight Ln, Suite #14 > > Olathe, Kansas 66062-4578 > > Office (913)829-0888 > > Fax (913)649-2904 > > Cell (913)915-3137 > > ================================================ > > Attention: > > The information contained in this message and or attachments is intended > > only for the person or entity to which it is addressed and may contain > > confidential and/or privileged material. Any review, retransmission, > > dissemination or other use of, or taking of any action in reliance upon, > > this information by persons or entities other than the intended > recipient > > is prohibited. If you received this in error, please contact the sender > > and > > delete the material from all system and destroy all copies. > > ====================================================== > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Claudine > > Robbins > > Sent: Saturday, March 19, 2005 12:36 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - RE: Access Violation Messages and Sys_Layouts3 table > > corruption > > > > Hi Javier, > > > > I'm working with a copy. I've tried deleting both rows and even though > > RScope no longer reports the problem, the Access Violation Messages > > continue... > > > > Claudine > > > > > -----Original Message----- > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier > > > Valencia > > > Sent: Saturday, March 19, 2005 12:33 PM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - RE: Access Violation Messages and Sys_Layouts3 > table > > > corruption > > > > > > Hi Claudine: > > > Whatever you do...backup first!!! > > > Then you can try deleting the offending items and see if that fixes > the > > > problem; if it does not, you still have the original... > > > Javier, > > > > > > Javier Valencia, PE > > > President > > > Valencia Technology Group, L.L.C. > > > 14315 S. Twilight Ln, Suite #14 > > > Olathe, Kansas 66062-4578 > > > Office (913)829-0888 > > > Fax (913)649-2904 > > > Cell (913)915-3137 > > > ================================================ > > > Attention: > > > The information contained in this message and or attachments is > intended > > > only for the person or entity to which it is addressed and may contain > > > confidential and/or privileged material. Any review, retransmission, > > > dissemination or other use of, or taking of any action in reliance > upon, > > > this information by persons or entities other than the intended > > recipient > > > is prohibited. If you received this in error, please contact the > sender > > > and > > > delete the material from all system and destroy all copies. > > > ====================================================== > > > > > > -----Original Message----- > > > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Claudine > > > Robbins > > > Sent: Saturday, March 19, 2005 12:24 PM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - Access Violation Messages and Sys_Layouts3 table > > > corruption > > > > > > Hi all, > > > > > > We had a small surge at the office yesterday and one of my db's is now > > > constantly giving off access violation messages which cannot be > > resolved. > > > > > > Upon running RScope 7.5, I find that there is an error in my > > sys_layouts3 > > > table which cannot automatically be fixed because it contains a note > > > field. > > > This table has two rows, one for an existing 'important' table, the > > other > > > for a view which I can easily delete and recreate. > > > > > > What should I do? > > > > > > Claudine
