Corrupted file with phantom index (AREV32) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"AREV32" author:"Robert Heard" author:"Andrew McAuley"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Corrupted file with phantom index (AREV32) ====
=== At 04 MAY 2024 12:40:12AM Robert Heard wrote: ===
 
 
<QUOTE>
Hello AREV32 fans,



I have a file that I must have had an index, as LISTINDEX will list this file. It shows "NO" in all index columns (Btree, Crossref, Related). I have another file like this, but it is a genuine indexed file that receives related index info from other files.



When I look at the records in the "!" file, they report on a file called "STUFF1", which I cannot find on any of my Volumes. 



I tried to delete my problem file from the OI Database File menu (it's meant as a temporary holding file), but it says that it cannot delete this file.



Can someone please advise how I can clear this file of this phantom index? I am happy to delete the file, as it is basically empty. Any ideas how this situation might have arisen?



Robert.
</QUOTE>
----

=== At 07 MAY 2024 09:29AM Andrew McAuley wrote:  ===

<QUOTE>The most likely situation is that the file has a relational index pointed at it. What's in the !TableName row?



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 07 MAY 2024 06:59PM Robert Heard wrote:  ===

<QUOTE>Hello Andrew,



!JUNK3 rec in !JUNK3 file:



JUNK3*ADMIN*AREV32_26784\*\\STUFF1  0 1 





I am unable to locate a file called STUFF1, even in unattached volumes.



Robert.

</QUOTE>

----

=== At 07 MAY 2024 07:17PM Andrew McAuley wrote:  ===

<QUOTE>Are the backslashes representing field marks?



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 08 MAY 2024 05:00AM Andrew McAuley wrote:  ===

<QUOTE>I think this is telling you that you used to have an XREF index on a [i]column[/i] in the table called STUFF1. [url=https://revelation.wiki/doku.php?id=kb:kb_articles:kb0194]Removing indexes manually[/url] is probably your best bet.





[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 16 MAY 2024 02:56AM Robert Heard wrote:  ===

<QUOTE>Hi Andrew,



No joy here, I'm afraid.



I found 3 occurrences of JUNK3 on 3 different volumes and applications. I deleted all of them.



Then I tried the attach of the ADMIN volume (and applicaton) to REVMEDIA from the SYSPROG applic as stated in the instructions. It did not show the JUNK3 file nor the !JUNK3 file, but only showed GLOBAL files.



But when I did the attach from the ADMIN applic, at least one of these files was listed. (can't remember if !JUNK3 or JUNK3). 



I tried to create a new JUNK3 file via the DB Mgr and it opens the Table Builder. But then it complains that an error occurs and says that DICT.JUNK3 already exists.



But then I tried to find / delete this dict file, (something) said it does not exist.



Apologies for the confusing description above, but I found I was going in circles and cannot remember where exactly these errors occurred.



I think that when I listed the tables in the volume via DB Mgr Tools, it did not show !JUNK3, but when in AREV32 and use LISTVOLUME, there it is.



Also, I am unfamiliar with NLM and NT products that are mentioned at the beginning of the doc regarding removing indexes manually. Can you point me in the right direction on this?



Robert.







</QUOTE>

----

=== At 23 MAY 2024 12:59PM Andrew McAuley wrote:  ===

<QUOTE>If you're not familiar with them and not using them you can probably skip those bits.



Basically all you have to do is remove any trace of the indexes. So remove the index flag from field 6 of the dictionary item, delete the ! file and all should be good?



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=2573A3F7674FB843A042FDF6CDADB345|View this thread on the Works forum...]]