Solved

Record Lock (3.12) Threshold Exceeded

Posted on 1998-06-30
1
436 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

734 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