Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index File corruption
Message
 
To
29/10/2002 10:15:41
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00716437
Message ID:
00716669
Views:
22
What version of the Novell client are you running? There have been various issues with various clients. I haven't kept up on the current problems. The things to try setting on the Novell client on the user machines is: (Under the Advanced Settings Tab)

Cache Writes=OFF
Delay Writes=OFF
File Cache Level=0
Packet Burst=OFF
True Commit=OFF

Not sure if all of these are still necessary, but those changes should help.

Also, turn off compression on these files on the server.

Some people recommend just using Microsoft's Novell client, but this isn't always possible.



>Hi all,
>I've an accounting app running on a Novell network running on both TCP/IP and IPX/SPX protocol via Win 98 terminals.
>The problem is that index files get corrupted practically every day. Every time reindexing fixes the problem. How the index corruption manifest itself is that some records go missing when searched.
>I've tuned the Novell setting as suggested by other members on the forum (disabling write behind cache, enabling extended file locks etc) but the problem does not go away.
>Is there a methodology or software tools that I could use to narrow down and identify the cause of the problems?
>The tables involve have 4 tags one for the surrogate key, document number, date and deleted().
>What is funny is that every time when the index is corrupted, some records go missing. I've used browse to look at the table and found a strange behaviour for the missing records. With set deleted off, I could see those records and the delete mark is not there but with set deleted on, I could not see the records at all!
>Any help on this would be very much appreciated.
>Yau
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform