Solved

Record Lock (3.12) Threshold Exceeded

Posted on 1998-06-30
1
428 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
WiFi Networking 3 441
GroupWise 6.5.7 Webaccess not load (Page Fault) 5 804
E-Mail to Specific Domain Not Working 7 197
What is the file extension of a GroupWise Archive? 2 1,525
Originally, this post was published on Monitis Blog, you can check it here . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 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