Hi Sami I did several times, still same problem with the errors and N's set for select on the sys tables.
Is it OK that the select value is set to N for the sys tables? Marc ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, December 29, 2004 8:05 AM Subject: [RBG7-L] - Re: Sys_layout3 problems again > 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] > > > > > >
