Solved

Record Lock (3.12) Threshold Exceeded

Posted on 1998-06-30
1
437 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

635 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