Dennis,
If you're using R:BASE 6.5++ (Build:1.866 or higher), the first step is to use the PACK INDEX FOR tablename or PACK INDEX (see below for options). If that doesn't help, then use the UNLOAD and INPUT option.
Tip: Before using AUTOCHK, UNLOAD or RELOAD command, make sure to DROP all TEMPORARY Tables/Views, if any. Or simply DISC/CONN to drop any TEMPORARY Tables/Views automatically.
Hope that helps!
Very Best R:egards,
Razzak.
At 07:17 AM 5/4/2004 -0400, Dennis Fleming wrote:
If File 3 is badly damaged, can you still Pack Indexes, or is an Unload/Input required? See below from Autochk: >>>
Examining table USAGE Foreign Key: #92 Foreign Key: #91 Foreign Key: #90 -ERROR- A column's index file reference is invalid. (1239) Index: 45 -ERROR- A column's index file reference is invalid. (1239) Index: 44 -ERROR- A column's index file reference is invalid. (1239) Index: 43 -ERROR- A column's index file reference is invalid. (1239) -ERROR- A column's index file reference is invalid. (1239) -ERROR- A column's index file reference is invalid. (1239) -ERROR- A column's index file reference is invalid. (1239) -ERROR- A column's index file reference is invalid. (1239) Column: TR_CODE Column: TR_DATE Column: PR_NBR Column: TR_QTY Column: TR_UNITP Column: EQ_NBR Column: TR_PO Column: TR_ACCT Column: VN_ID
Thanks,
Dennis *****
At 02:15 PM 5/3/2004 -0400, you wrote: >At 12:54 PM 5/3/2004 -0500, J. Stephen Wills wrote: > >>I've received an error dialog several times since last week as follows : >> >> CAPTION BAR READS >> R:BASE 2000 v6.5++ - [VRFY2003]: RBG65.EXE - >> Application Error >> >> MESSAGE TEXT READS >> The instruction at "0x00750eaf" referenced >> memory at "0x00000000". The memory could not be "read". >> >>Then, another dialog exactly like this one follows. >> >>Then, the following >> >> CAPTION BAR READS >> R:BASE 2000 v6.5++ - [VRFY2003]: RBG65.EXE - >> Application Error >> >> MESSAGE TEXT READS >> The exception unknown software exception >> (0xc0000027) occurred at location 0x7c58f012. >> >> >>It's 6.5++WIN 1.866xRT03 running on WIN2KPRO, plenty of HD space and RAM, >>nothing exotic and never happened before. >> >>I first encountered when a command file attempted to INSERT ... a >>combination of variables and constants into a target table. This command >>was syntactically correct, had been executed many times in the past, and >>threw the same error when run at the command-line. Additionally, all >>table structures and data types checked out correctly. >> >>So, thinking that maybe something was wrong with the meta-data/system >>tables, I figured I'd pack this database. It threw these same >>dialogs. That's when I figured it was time to ask for some input. >> >>So, anybody have any, please? > > >Steve, > >Look like the corrupted index or broken pointers. > >Try the following techniques to take care of that: > > >01. Start R:BASE 6.5++ for Windows > >02. CONNECT dbname IDENTIFIED BY user password > >03. At the R> Prompt: > > PACK INDEX FOR tablename > > This will pack all the indices for the specified table, even in a >Multi-User environment. > > Or > > PACK INDEX > > This will pack all the indices for currently CONNected database, even >in a Multi-User environment. > >Now try the same INSERT routine and see what happens. If that doesn't help, >then RELOAD the database. > >For complete details: http://www.razzak.com/fte > > From The Edge: Finding and Fixing Broken Indexes (04/30/2002) > >Have fun! > >Very Best R:egards, > >Razzak. > > > Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797 Cell: 570 351-5290
