Arana (G.P.)
asked on
corrupt table how to fix?
pervasive 2000
i have never used pervasive , i once used btrieve back in the gwbasic days (a lot of time eh?)
i am mostly into oracle,vb,mssql and other, but not pervasive,
The problem is a friend wich has no idea of nothing hehe, got a corrupt table and their frontend system is crashing, so she viewed the data using some pervasive tool, and says data from the last record "JUMPED FIELDS"
that is data from one field appeared in another and so on, the data jumped to the next field in the table, so data that should be on a field date appeared in another field, data from some numeric id, appeared in a description field, etc
i tought this was a development bug, but she said she has being using that system for two years without problems , and even if it was, the how could DATE data get into another field 8maybe in pervasive is possible, but not in other DBMS i know),
the question:
how to repair that table or the database?
how to invoke the repair utility if there exists one?
or how to manually deal with the problem?
HAVE TRIED: copying all data to another table but she cannot! (some error about indexes being wrong ), she cannot delete that last record also
so i think that she shold REPAIR , but she does not know how, neither do i
HELP PLEASE, i know it is not much info, but she is not a tech user, and she is not in my city, so if you need to know anything, just ask me , so i can ask her :)
i have never used pervasive , i once used btrieve back in the gwbasic days (a lot of time eh?)
i am mostly into oracle,vb,mssql and other, but not pervasive,
The problem is a friend wich has no idea of nothing hehe, got a corrupt table and their frontend system is crashing, so she viewed the data using some pervasive tool, and says data from the last record "JUMPED FIELDS"
that is data from one field appeared in another and so on, the data jumped to the next field in the table, so data that should be on a field date appeared in another field, data from some numeric id, appeared in a description field, etc
i tought this was a development bug, but she said she has being using that system for two years without problems , and even if it was, the how could DATE data get into another field 8maybe in pervasive is possible, but not in other DBMS i know),
the question:
how to repair that table or the database?
how to invoke the repair utility if there exists one?
or how to manually deal with the problem?
HAVE TRIED: copying all data to another table but she cannot! (some error about indexes being wrong ), she cannot delete that last record also
so i think that she shold REPAIR , but she does not know how, neither do i
HELP PLEASE, i know it is not much info, but she is not a tech user, and she is not in my city, so if you need to know anything, just ask me , so i can ask her :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The recover and load should take care of the indexes. The DDFs will not need to change as long as the file is in the same directory as before.
Well?
ASKER
THANKS A LOT, this was going ok, as you said and as she expected, at the asmetime their system provider was helping them and they finished very quick (it cost a lot also, but was not my money or hers hehe),
your answer is good and was doing the job, my friend is not so good, and she was slower than the service provier, anyhow thanks for the info, since thanks to it NOW I KNOW at least two things about pervasive and how it works
1.- it can be fixed
2.- stay away from it! :P :D
your answer is good and was doing the job, my friend is not so good, and she was slower than the service provier, anyhow thanks for the info, since thanks to it NOW I KNOW at least two things about pervasive and how it works
1.- it can be fixed
2.- stay away from it! :P :D
Pervasive rocks! It's the fastest around. I have customers with over 20 million records in a DB and they get sub-second retrievals. But, if you don't know what you are doing, stay away.
Note: The database should be faster and smaller now that she rebuilt the indices.
Why did they pay someone?
Note: The database should be faster and smaller now that she rebuilt the indices.
Why did they pay someone?
Thank you so much for this article. I tested on a file with a status 2 Disk I/O error and managed to recover 108013 records out of 108015.
ASKER
what about rebuilding indexes? and DDF?