The index record FILENAME** is missing errors (AREV Specific)
At 30 JAN 2003 06:23:22PM Bill Weingarten wrote:
Help!
A customer site has started receiving the message: 'The index record "FILENAME**" is missing. The index field "FIELDNAME" in the file "FILENAME" should be rebuilt.'
This is happening for multiple BTREEs in the same file. I have deleted the all indexes for the file (as instructed by Technical Bulletin #56) and rebuilt them from scratch twice but the problem is still occurring.
They are running AREV 2.11 on a NT 4.0 Server from workstations running Win98, 2000, and XP. The program has been running fine for many years and has never experienced this problem before.
This is a mission critical database so time is of the essence. Any help would be GREATLY appreciated.
Thanks!
- Bill
At 30 JAN 2003 06:33PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Are they running any network products? Have you tried deleting all the indexes to the level of removing the ! file? This is a quick and dirty and will not reveal the cause but may buy you time to investigate more thoroughly.
World Leaders in all things RevSoft
At 30 JAN 2003 10:15PM Warren wrote:
I've seen this before. There's an "orphan" index node sitting out in the !bang or a index record that points to an non-existant node that doesn't get deleted when you remove the indexes.
As Sprezzatura suggest remove the indexes completely from the file (Remove indexing from a file on the menu).
If you get the error message while doing that, just do a clearfile on the !file, then remove indexing, then add indexing back on to it.
You should probably download and apply the updates to v2.12.