Too many records locked
7-18-23
Operating system: Windows
Hello there.
Have a randomly message with text "Too many records locked". Helps restarting of server. What is this error and how to solving this?
Logs not had any unusual activity. Online max. 26 users.

SERP 2022-12-30. 85500120
7-19-23
Hello.

"LOCKED" record is the record in Update mode, the one that is currently edited by user (New is not counted here).
System has a limit of 100 records that can be in edit mode same time.
If this limit expires you are not able to edit another record and you will get message - "Too many records locked".
This means until somebody saves a record, nobody else can modify any other record.
It might be that if users are loosing connection server is still counting records that were updated by those users at a time.

Please check if it is possible that current number of users have so many records in update mode same time.

If the limit is too low we can possibly extend it.
If this happens due to some other circumstances it would need to be investigated if this is not a bug.

Regards
Agnieszka Klimkiewicz
7-19-23
Thanks for answer!
Is there possibility to check (report) what records are open or maybe how many records opened by the user's? Maybe some leaking with HAL customizations or webshop...
8-7-23
Created by15:26 19 July 2023
Thanks for answer! Is there possibility to check (report) what records are open or maybe how many records opened by the user's? Maybe some leaking with HAL customizations or webshop...
Hello. A report was created to calculate all open windows and their states on all clients. When this error pops up, only 5-10 windows are in an edit state on the customers' side.
Customer is using a lot of HAL customizations for the hotel and restaurant modules, but I don't know of any HAL functions that can lock a record without a window on the client side.
Perhaps there are some ways to lock records from HAL, and we have code with this issue?

For now error hapens once a day regullary. And server should be restarted.
8-8-23
I will check this issue with HW development department and let you know.

Regards

Agnieszka Klimkiewicz
8-21-23
I got information that problem was possible to be repeated in demo data so bug about problem shell be reported.

Regards
Agnieszka Klimkiewicz
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Piotr Wycichowski
Hi, I need very quick support. We've just upgaraded our SERP from version 250507/85558691 to 260126/85561335 (on Mac server). When server process was started, the folder EmailGateway was autom...
08:56 10 Mar 2026
Hi Bror-Erik, Thanks for your reply. We've done further testing and we've discovered that it is only my Windows 11 laptop that has this message about downloading components. Other coll...
12:04 27 Feb 2026