IT SOLUTIONS
Your TECHNOLOGY partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Tables Topic     Print This   

locking and table corruption problems

locking and table corruption problems in Paradox Tables topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: locking   corruption   problems   locking table   locking table corruption  

biondean

I have Paradox 8 and BDE patch 5.1.1

My problem is that two or more different users from differt PC can acces to same record and modify it wihtout any lock. Almost always this corrupts indexes and headers requiring a rebuild.

Now we can work only one at time....and it is almast tragedy in office....

Same .net directory path for all users.

Local share true or false seems not affect even since we all use only paradox.

Looking in directory I noted that .lck file are not creatred anymore. Oldest one is few months ago. I'm not sure this can affect but this could be the reason. I excpected to find in same directory where tables are.....and expected paradox to give an error message if there is not .lck file or could not create it.

Please help since company is "down" !

Thanks,
Dean
Reply With Quote

 Posted 42 months ago (Thread Starter)
Comment Quote
Location=?,  Joined=42 months ago   MB Posts=2  
More... -Collapse +Expand
biondean
?
Rank: Cadet 3rd Year
Email A E Unk
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13799, 2 replies
Thread Started 12/4/2009 1:39:13 AM
View Counter=1401
Last Reply Posted 12/5/2009 1:15:08 AM)

A. I. Breveleri

You say, "Same .net directory path for all users."   Did you check it with the BDE admin utility?

Are you sure the users' Paradoxes are using the correct configuration file?

Do you get an error when you start the user's Paradox?

The network lock file may be corrupted.  Go to the .net directory and delete the file "PDOXUSRS.NET".  (The first Paradox to start will re-create this file.)

-Al.

 Posted 42 months ago
Comment Quote
Location=Boston, MA, USA,  Joined=12 years ago   MB Posts=277  
More... -Collapse +Expand
A. I. Breveleri
Boston, MA, USA
Rank: Commander
Email A E MA USA
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13801 (Level 1.1)  Reply to 13799
Thread Started 12/4/2009 2:00:51 PM
Most Recent Post

biondean

Thanks for answer Al.

The updated my situation is following :

- I reinstalled paradox and BDE 5.11 

- form BDE tool i confirm that all .net are the same even the case

- i deletetd all .net and .lck files

- local share is set to true

- i managed to disable oplocks on all pc-s

- imanaged to disable write caching on pc without raid controller

- i'm not able to remove write caching on server (i think  most important) that has raid controller NVIDIA ....if you know some hints i would appraciate a lot

After this things goes better but not complteley ok. 

- paradox creates again lck files and locks records

- there is not refresh for changes made from another user unless you close or F5 lock again record

- in few hours no more corruption but only two users ...on monday more relevant test

So if you have ideas or know how to remove wrtie caching with raid thanks a lot,

Dean

 Posted 42 months ago (Thread Starter)
Comment Quote
Location=?,  Joined=42 months ago   MB Posts=2  
More... -Collapse +Expand
biondean
?
Rank: Cadet 3rd Year
Email A E Unk
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13802 (Level 1.2)  Reply to 13799
Reply Posted 12/5/2009 12:47:08 AM

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post:

Enter your name and security key.

Your Name:
Today's security key = P205A
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #13799 Counter
1401
Since 12/4/2009
-
  Load Time=4 seconds.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


1,113 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join now. It's free!
Show More...


©1995-2013 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech