Indexs corrupted daily after moving from Novell to Win2K Server

[jbb60]

We justed migrated from a Novell 4.10 server to a Windows 2000 Server (SP3). The clients are Win98 and one Win XP desktop. At least once per day, one of the three most used tables ends up with a corrupted index. The table repair utility is able to rebuild the table and indexes and we do not appear to be loosing any data in the tables. We are running PDox 10 on all of the systems. These problems did not occur while on Novell.

Local Share is set to true on all systems.
All systems are running the same version of BDE.
All systems have latest OS and PDox patches.
Most of the clients are running PDox 10 Runtime.

Any suggestions would be greatly appreciated.

 

[Langley]

have you disabled write-behind caching on the workstations? Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[Langley]

Also, make sure that opportunistic locking is turned on on the server. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[Langley]

Also, you can search the knowledgebase at Corel:

http://venus.corel.com/kbsearch/win32/paradox.html

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[NotAllThere]

In the interim, if only indices are being corrupted, use a reIndexAll() method to rebuild. Much faster than Table Repair. See ObjectPal Help for an example.

 

[Langley]

"Also, make sure that opportunistic locking is turned ON on the server"

That should be OFF, not ON!

I wish this silly board would let us edit. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[Kliot]

I had the same problem when I migrated, just as Langley stated turn off oppertunistic locking and your problem will go away. Visit

http://www.bdesupport.com/stability.htm

for details on how and what to do.

 

[footpad]

jbb60,

In addition to the other comments and links, be sure to check out the NT configuration FAQ at

http://www.thedbcommunity.com/faq/29.htm

for additional tips and ideas.

Hope this helps...

-- Lance

 

[jbb60]

Thanks for the help!!! I set the Win2K server to deny granting of opportunistics by setting:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\EnableOplocks = 0

I have not updated anything on the desktops because I support this systems remotely.

We have run three days with no issues.

THANKS AGAIN!!!