Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dealing with Invalid seek offset
Message
 
 
À
14/01/2015 02:13:00
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01613531
Message ID:
01613594
Vues:
46
>>>>I have converted my app to SQL Server database. So this has eliminated the corruption of the application DATA. But my app still, on occasion gets the "Invalid seek offset" error. The error happens when the application tries to access/open/load meta data which is still in the DBF format. I believe that "Invalid seek offset" is caused by some kind of PC memory corruption (be it from a buggy printer driver or some other).
>>>>
>>>>But I am thinking; what if I replace all my meta data tables from DBF to XML format. Will it eliminate this "Invalid seek offset" problem? That is, do you know if the corrupted memory is only causing the problem when opening DBF files? Or any file(s)?
>>>
>>>It has been a long time since I resolved that. The illigal offset in my cases Always had to do with Network connections that were dropped (even briefly). Since we've upgraded to SQL server and hold all the meta data locally or embedded in the executable, I have not seen it since.
>>>
>>>Walter,
>>
>>My app is also using SQL Server and the meta data are in the executable. But still, once in a while, I get messages (from customers) of that dreaded ISO error. This is why I am thinking of changing meta to XML. I presume that your meta data is DBF, right?
>
>Yes. DBF. I've never encountered problems with that. Where is your executable run from? From the network or from the workstation? If from the network the problem could just be that the network connection is lost. VFP reads the executable when running code. If the networkconnection drops, the executable cannot be read anymore and an Illegal Seek offset will be thrown.
>
>Best is making sure using a launcher and make sure it is run locally from the workstation.
>
>I do not think that a change to XML would change anything. The cause is unrelated to the DBFs if they are embedded in the executable.
>
>Walter,

My application EXE is always run from the network drive (shared folder). So it does make sense; now that I think about it, that networking issue could cause this problem. I don't want to change to a launcher and local drive. It may resolve some issues and introduce new ones.
And I will not convert to XML. But I will add some TRY/CATCH code to the places where application loads meta tables. This way, if ISO happens, the user will have a choice to try it again. Just in case the networking issue was a glitch.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform