[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Database Manager / No Indexes - Yet there are (OpenInsight Specific) ====
=== At 29 JUL 1998 03:49:38PM Tom Horan wrote: ===
{{tag>"OpenInsight Specific"}}
I'm in OI 3.12. I have indexes on several files. I can access these files using a index lookup and it works fine.
Problem:
When I go to DataBase manager to view/update index files, it says there are no files with indexes.
Why is this. How can I fix it..
Suggestions
----
=== At 30 JUL 1998 11:24AM Dave Pociu wrote: ===
Ah, yes, I remember this problem!
OK, here's what you do:
- From System Editor run this command "run list_index"
- this should get you a list of indexed tables and their index types
- More than likely, one of the tables has a problem with one of the indexes.
- Fix that problem, then try again.
- When everything looks OK here, try DataBase Manager. It should display everything
I think in one of the later releases (3.5 or 3.6 ) Cameron added a fix for this. In previous releases, as soon as an error is encountered by list_index, the Database Manager does not display anything in the index list.
Hope this does the trick.
Dave
----
=== At 30 JUL 1998 12:03PM Tom Horan wrote: ===
Dave,
Thanks it worked great.
----
=== At 29 OCT 1999 06:43AM Thanks, Dave Pociu wrote: ===
Dave,
My Database Manager suddenly wouldn't show me any indexes. But this old posting of yours helped me out.
The cause wasn't a problem with an index but a table that had no DICT. But List_Index revealed that too.
Btw - I run version 3.61, so it cannot have been fixed in 3.5 or 3.6 like you believed.
- Oystein -
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=433523C82027125585256650006CEA42|View this thread on the forum...]]