>>I copied data from production backup to my local drive. Every time I'm trying to do either ProcessNewTrans or LoadNewTrans on a big file I get this error when I run the process the second time. I'm using private datasession (session class), Delete ON, tablevalidate = 7
>>
>
>I've been fighting this error with a couple of clients. In one case, it seems to have been the machine. With the other, we think it's a network problem.
>
>You'll also get the ISO error if an index is corrupt. Make sure you've rebuilt all the indexes from scratch (not just REINDEX).
>
>Tamar
I'm using SDT from Doug Henning and it has Reindex option, which I believe rebuilds all the indexes.
The problem is, that I try to load the file what was already loaded. Therefore it should create duplicate records (the PK would be different, of course). I got the error consistenly. One try may work and the second will produce an error :( Especially if I try to run them without closing VFP session...
Right now it's still running for 5K records, but I'm not optimistic about it... :(
If it's not broken, fix it until it is.
My Blog