Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Seek Offset - reproducible
Message
 
 
To
21/07/2006 12:26:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137918
Message ID:
01138588
Views:
15
>I have the impression that the indexes get corrupt by a sequence of actions
>
>A couple of things are worth trying
>
>(1) limit the cache
>
>=sys(3050,1, 64 * 1024 * 1024)
>=sys(3050,2, 16 * 1024 * 1024)
>
>
>(2) after every insert/update
>
>flush
>=sys(1104)
>
>
>(3) go top, then seek
>
>
>You'll quickly find out whether the above helps

Haven't yet tried your idea. I cleaned indexes in Stage tables in my local copy (which already had one Invalid seek offset) and then try to run it again. I got:
Error: 1103
LineNo: 1099
Message: Invalid seek offset.
Procedure: runprocess
Details:
StackLevel: 2
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform