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
Hello, Kindly please report the bug so that we can further investigate and resolve it. Thank you. Best regards, Benjamin...
11:31 3 May 2024
Hi, No changes should have been made that would increase client's HDB file. Please try to delete HANSA.HDB from client folder and reconnect to server and check if it will grow to 30MB again. ...
10:14 30 Apr 2024