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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
