More info, tested twice with one of my PC support guys watching as a witness. (sanity check)
I connected to an old DB (12/31/2009) and no problems even after adding a owner name. Connected to the live db using connections history without closing the RBase session. Unable to recreate the error. Closed RBase, opened a new session, connected to the live DB first without opening an old DB using connections history, set layout on, error is back. Strange! Tried granting all privileges on sys_layouts3 to public, still able to generate the error. Tested the Live DB again and it still seems OK, I guess I will wait till after hours and unload and rebuild tonight. Kenny From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp Sent: Monday, May 10, 2010 1:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error SYS_Layouts3 does not exist - But it does. I granted all privileges to PUBLIC. And while working as the DB owner and layout on and with multi off (single user) I still get the error. I do not in the DB prior to adding the DB owner name. I was able to stop the error messages for users in the compiled version by editing the rbengine76.cfg and saving with layout off. But is the DB OK? Kenny From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Monday, May 10, 2010 1:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error SYS_Layouts3 does not exist - But it does. Kenny, give your users permission to access, and update if you want them to save the layouts, the sys_layouts3 table. Regards, Alastair. From: Kenny Camp <mailto:[email protected]> Sent: Monday, May 10, 2010 6:55 PM To: RBASE-L Mailing List <mailto:[email protected]> Subject: [RBASE-L] - Error SYS_Layouts3 does not exist - But it does. Could someone tell me what is happening in my live database? I made many changes to my main database this weekend mostly adding a owner name and granting all privileges to public, and granting create to public to allow temp tables. This morning everything was OK for several hours until some compiled version 7.6 users started getting this error message. Error SYS_Layouts3 does not exist. I opened the database with the full version 7.6 and R> list sys_layouts3 it is there with 4 rows. R> browse all from sys_tables3 showed the error and after clicking past the error, it showed the data. I reloaded the database, but the error returned after a while. This system table saves custom layouts that we do not use. Autocheck full shows no errors, and the database appears to be OK. Comparing compute rows and compute count (1) from table gives the same number, so I don't believe it is a broken index. I want to unload and rebuild, but need to wait till after hours if possible. I found layout was set on and so set layout to off and the error does not show up any more in the full version but still appears when calling the browser in the compiled version. Any clues? Kenny _____ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2865 - Release Date: 05/10/10 07:26:00
