Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index File corruption
Message
From
30/10/2002 10:34:20
 
 
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:
00716880
Views:
13
Yau,

A very long time ago, in a large (30+gigs of table data) I encountered a similar problem with corrupted .CDX files (thankfully, never .DBFs).

THAT problem was eventually resolved when we found out that the very fancy/costly server hardware had not been 'certified for Novell' (as my boss put it) and was replaced by a Compaq server-class PC with StorageWorks DASD array hardware.

I'd personally doubt that that is the problem in your case, but Imention it because you haven't had much luck here to date.

Tell us more about the configuration AND about the reliability of power where the problem is happening.
NOS name and version
NOS machine information including HD info
Confidence in network configuration/cabling
Workstation OS, maintenance levels, RAM

good luck


>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
Reply
Map
View

Click here to load this message in the networking platform