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