Marc - I would do an UNLOAD ALL and let R:BASE rebuild your database from scratch ...
Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Wednesday, December 29, 2004 7:41 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Sys_layout3 problems again Thanks Albert I didn't know that. If I try just granting select to Sys_layouts3 I get the same errors but if I do Grant Select...to public at the R> I do not get any errors. When I look at the rights for the sys tables for Public all of the Select values and all other values are set to N. Is that correct or should I set Select to Y for all sys tables? Marc ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, December 28, 2004 8:47 PM Subject: [RBG7-L] - Re: Sys_layout3 problems again > Marc, you can only grant SELECT to most of the sys tables. Most of them are actually views. You > can grant all privileges to the sys_form.. and sys_report.. and sys_label.. tables except modify. > > > --- Marc <[EMAIL PROTECTED]> wrote: > > > Thanks Albert > > > > I tried that no errors. > > > > Then I > > Con to db entered owner password > > went to table privileges ... public... sys_layout3 > > everything was N across the screen, even for all > > sys tables. > > I clicked Edit, checked all of the boxes for select, > > update... and all of the columns below, clicked OK > > Then I got 3 errors > > Error column sys_layout_name not in RBdefine > > Error column sys_data not in RBdefine > > I got this for each column in each sys table when I > > tried it on the other sys_tables. > > > > I thought build 78 was suppose to grant access to public > > on system tables? > > > > Maybe I need to delete the sys tables then do the upgrade again > > since this db was converted / upgraded before build 78? > > > > Is this normal or does this mean something is wrong? > > > > Marc > > > > > > > > > > > > > > ----- Original Message ----- > > From: "Albert Berry" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Tuesday, December 28, 2004 3:11 PM > > Subject: [RBG7-L] - Re: Sys_layout3 problems again > > > > > > > A favoured technique when unusual problems arise is to do an unload/input > > for the database. > > > > > > CONNECT <database> > > > SET NULL -0- > > > OUTPUT <database.str> > > > UNLOAD STRUCTURE > > > OUTPUT SCREEN > > > OUTPUT <database.dat> > > > UNLOAD DATA > > > OUTPUT SCREEN > > > > > > Now edit the database.str file. Search for ALTER. > > > Add two lines here: > > > RETURN > > > LABEL Indices > > > > > > and save the file. > > > > > > SET MESSAGES ON > > > SET ERROR MESSAGES ON > > > OUTPUT RELOAD.LOG > > > RUN database.str > > > This will create the structure without indexes and constraints > > > RUN database.dat > > > This will load all the data back into the database > > > OUTPUT SCREEN > > > Again edit the database.str file > > > As the first line > > > > > > GOTO Indices > > > > > > Save the file > > > > > > OUTPUT RELOAD.LOG APPEND > > > RUN Database.str > > > OUTPUT SCREEN > > > > > > > > > This will add back the indices and constraints. > > > RBEDIT RELOAD.LOG > > > Search for the word "ERROR" to see what has gone wrong. > > > > > > > > > > > > > > > > > > > > > > > > --- Marc <[EMAIL PROTECTED]> wrote: > > > > > > > Hi all > > > > > > > > I thought this problem was solved a few months ago but > > > > it is back. I haven't used this db since then so I am not sure > > > > when it came back. > > > > > > > > If I con to the db then enter the owner password > > > > then do Edit all from table I get an error about > > > > a missing sys_layout3 table. But it is there at the > > > > R> when you do list sys%. > > > > > > > > If I put in the owner password first then con to the > > > > db, then edit all from table NO error. > > > > > > > > I have looked for dup MSG and DLL files. > > > > Deleted the CFG file, upgraded the DB, > > > > reloaded..... > > > > > > > > This may not be a big deal since I can work around it > > > > but it makes me nervous that there may be something > > > > else wrong with my db and it will come back and > > > > cause problems one day. > > > > > > > > Any suggestions? > > > > Marc > > > > > > > > > > > > > > > > > ===== > > > Albert Berry > > > Management Consultant > > > RR2 - 1252 Ponderosa Drive > > > Sparwood BC, V0B 2G2 > > > Canada > > > (250) 425-5806 > > > (250) 425-7259 > > > (708) 575-3952 (fax) > > > [EMAIL PROTECTED] > > > > > > > > > > > > > ===== > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] > >
