Corrupt PRO-ISAM File
Posted 11 October 2002 - 06:10 PM
Posted 11 October 2002 - 06:26 PM
depending on the key structure if you could perform direct reads on the corrupt file and then write it to a temp file.
Also sneaking up on the corrupt area and then exiting the function and re-enter the function and set the key past the corrupt area and continue on. You will lose data but retrieve the valid data.
I have found that running it on a SCO unix server(as a pro 4 update or ischk) gives better results than on a W? or Linux version of Pro4.
There is also the pro-isam file utility people? Have not used them but they are out there. http://www.net-aware.com/
Posted 12 October 2002 - 03:55 AM
Never repair a file using ISCHK.
If you get a corrupt PRO-ISAM file, use ISCHK to see if there is an error. This will only give true results if all users are logged off the system. ISCHK will report errors if users are logged on.
When you run ISCHK - do NOT use the repair option.
After running ISCHK, the best course of action it to ISOUT the corrupted file, move the original corrupt file & ISIN again.
I've never had a problem with this method.
Posted 15 October 2002 - 12:55 AM
I have once encountered with corrupted PRO-ISAM file. The situation was:
- There was garbage in the middle of file; the function can read from the top of file till it reached the corrupted records, but once I started from the record after the corrupted records , the function continue read till the end of file. I checked with iskeys command.
The way to fix this problem:
- use isout with 'end key' option, create a seq file from the 1st record till the record before the corrupted record. You may name it as 'data1.seq'
- use isout with 'start key' option, create a seq file from the record after the corrupted record till the end of file. You may name it as 'data2.seq'
- change the name of your corrupted file (such as 'corrupteddata.pro' or whatever but don't delete it), then use isin for both 'data1.seq' and 'data2.seq' to recreate a new PRO-ISAM data file. You will lose only the corrupted records.
Hope this will help
Posted 23 December 2012 - 12:05 AM
Invalid Index Level: page 0x1
Invalid Page Leght: page 0x1
and when try use isout the meesage error is:
Error reading empldos.pro; FS_EBADINDEX invalid index structure
[107 - invalid Index - Rebuild ]
I need rebuild the index.
How i do this?
Sorry for my bad inglish
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users