Thanks for this interesting tip, Albert! David
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, December 28, 2004 4: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] >
