Solved

Record Lock (3.12) Threshold Exceeded

Posted on 1998-06-30
1
416 Views
Last Modified: 2008-03-03
Have the following message on the server, "Station 125 record lock threshold exceeded, total violations 254043"
I SET "Maximum File Locks Per Connectin: #" to 500 but
continue to receive error, user database is 6GB.  
Thanks in advance!
kras@ria.org
0
Comment
Question by:kras
1 Comment
 
LVL 5

Accepted Solution

by:
jstegall earned 70 total points
ID: 1592739
That looks like the 500 is not enough.  See the below TID
record lock threshold exceeded  (Last modified: 03MAR1998)

     This document (2935504) is provided subject to the disclaimer at the end of this document.
         Forward this document to a colleague
        Submit comment about this document to its author

     Symptom

     When starting MS Access application, the following error message at the server console
     appeared:

     Station x record lock threshold exceeded. Total violations #####

     Cause

     MS Access heavily uses file and record locks in the database files and the default limit per
     connection (NW4.11: 500) is exceeded very easily.

     Solution

     Here are the SET-parameters you need to modify:

     (the default values are for NW4.11)
     Maximum Record Locks Per Connection (default: 500, range 10 - 100000)
     Maximum File Locks Per Connection (default :250, range 10 - 1000)
     Maximum Record Locks (default :20000, range 100 - 400000)
     Maximum File Locks (default: 10000, range 100-100000)

                    Please select if this document solved your problem.

      Document Title:
                          record lock threshold exceeded
      Document ID:
                          2935504
      Creation Date:
                          02MAR98
      Modified Date:
                          03MAR98
      Document Revision:
                          1
      Novell Product Class:
                          NetWare OS
      Novell Product and Version:
                          intraNetWare


     DISCLAIMER

     The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this
     information. However, the information provided in this document is for your information only. Novell makes no
     explicit or implied claims to the validity of this information.

     Any trademarks referenced in this document are the property of their respective owners. Consult your product
     manuals for complete trademark information.

----
And from:2909145
Symptom

     The user was getting system record lock threshold exceeded error messages.

     Solution

     Use the Server Manager Utility to increase the set parameters for Maximum Number of Record
     Locks and Maximum Number of Record Locks per Connection.
HTH
       
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Groupwise to pst 3 895
How to setup Novell Netware 6.x server? 5 515
vmware player with netware client can't find tree 10 1,243
DOS NETWARE CLIENT ( E100BODI.COM CAN'T LOAD) 9 927
Employees depend heavily on their PCs, and new threats like ransomware make it even more critical to protect their important data.
An article on effective troubleshooting
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question