Can't update indexes (OpenInsight Specific)
At 04 JUL 1999 01:54:19AM Greg Hofer wrote:
When going into the Database Manager and selecting the update index option under the utilities menu, I get a message saying that none of my tables have indexes. If I select the add index option it lists my tables and it shows I have several indexes defined.
I remember that this happened before a few times and I deleted all of my indexes and rebuilt them. Is there anything else I can do to find out what is wrong? I'm still using version 3.5. Does 3.7 have fewer problems with indexes getting corrupted? How much would an upgrade be to 3.7?
Is my data actually safe in this database? A while ago I had tables populated with data and I added a few indexes and all of the data vanished. This happened a few times in fact. I have one table as well that has records in it that I can't delete. I can't add anything into it either. Maybe this is causing problems for me.
I also found that when I installed McAffee virus scan on my computer that OpenInsight wouldn't even start until I removed the virus scan s/w. Has anyone ever had a problem with that?
Thanks.
- Greg
At 04 JUL 1999 04:12AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
If you can't see any indexes the strong likelihood is that one of them has become corrupt. Got the the system editor and type in the exec line
run list_index
this will show you which one is broken.
If McAffee is not explicitly told to ignore OV files it can interfere with OI as it thinks they are overlays and they keep changing - a bad sign to AV software.
Disappearing data/indexes are not good. Generally indicative of some fault somewhere. Sorry to sound so vague!
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 04 JUL 1999 11:07AM Greg Hofer wrote:
Thanks for your repsonse. That is indeed what is happening. It lists all of the indexes up to a table called "criteria3" where it prints a message:
SYSREPOSLOCKS APPUSERSTATUS 1 0 0
FS401: The "DICT.CRITERIA3" table has not been created or attached.
What does this mean and how do I re-attach an index? Thanks.
- Greg
At 05 JUL 1999 03:14AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Can you open records in Dict.criteria3 in the system editor? If not try detaching Criteria3 and saving database definition then re list_index ing. Essentially keep fixing the errors until list_index works….
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 05 JUL 1999 10:10AM Greg Hofer wrote:
Thanks for your response. I ran list_index and it listed a problem with "DICT.CRITERIA3" which was with a table CRITERIA3 that I had deleted through the database manager a while ago. Is the database manager not the correct place to delete tables? Thanks.
- Greg Hofer
At 05 JUL 1999 10:14AM Greg Hofer wrote:
Hey Andrew, for some reason I can't respond directly to your post. Thanks for your response though. I did the "run list_index" thing and it showed a problem with "DICT.CRITERIA3". The "CRITERIA3" table was one that I deleted a while ago through the database manager. Isn't the DICT file supposed to get deleted along with the table or is the database manager not the correct place to delete tables? Thanks.
- Greg
At 05 JUL 1999 10:21AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
Most likely the file has a GFE. Run through the database manager and verify the file. After fixing the GFE's, it should start returning. You will have to verify all your dictionary fields are still there.
akaplan@sprezzatura.com
At 05 JUL 1999 11:59AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
yes but having deleted the table you MUST resave the database.
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 06 JUL 1999 07:47AM Cameron Revelation wrote:
Greg,
From the command line:
run detach_table "CRITERIA3"
run detach_table "DATA.CRITERIA3"
run detach_table "DICT.CRITERIA3"
run detach_table "!CRITERIA3"
Now go the database manager and save the database definition.
Cameron Purdy
Revelation Software
At 08 JUL 1999 02:53PM anders Lindholt wrote:
You may have to delete the information in your dict.tabel records on pos nr 6.
if it's a btree index the value is set to 1.
It's not always been remove then you delete the index'es, therefore you have to do yourself; remove the information or use 0.
Remove/add the tables.
best regards
anders
anders