Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Record Lock (3.12) Threshold Exceeded

Posted on 1998-06-30
1
Medium Priority
?
457 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 280 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Following on from our article on "The Murky World of Consent and opt in", we thought we would issue some helpful guidance, not only on consent itself but knowing what information you are capturing, what you are doing with this data and how you can p…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month9 days, 22 hours left to enroll

927 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