Client Hansa.HDB
4-29-24
Operating system: Windows
Hi there,

We're looking at the latest version (8.5 2024-03-16) and we've noticed that the client side HDB file is now quite large (30MB) compared to the previous versions (1-2MB). What is the reason for this increase in size? Is there any other data being stored locally rather than server side in this new version?

We note the executable file has also got larger too - again, any reason we should be aware of?

Thanks


Best wishes

Dave Briggs
4-30-24
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.

We have not seen this in other environments running on current released version 2023-03-16.

Best regards,
Rasmus
6-11-24
Created by10:14 30 Apr 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. We have not seen this in other environments running
Hi again,

We have a customer on version 2021-04-21.

We have noticed an issue with the client hansa.hdb files increasing in size . We have seen this happening on our Windows Test Server but the customer is also now reporting the same issue on their Live system. They are reporting several instances where they have had to create a new client installation as the client stops responding periodically, or slows down, and we believe this is because the size of the local hansa.hdb has grown too big.

They kept hold of a copy of an example of a previous installation and we found that the hansa.hdb was 549MB. Re-installing the client worked okay for them and we found the same on our test server and deleting the hansa.hdb and re-connecting also works.

However during our testing the new hansa.hdb then starts to grow again. This doesn’t happen each time we create a new installation/hansa.hdb and we haven’t been able to pinpoint what triggers this, we’ve tried re-starting the service and updating the halcust but that doesn’t seem to be it.
We have looked back at the previous installations from our test server and our hansa.hdb’s had reached sizes of 425MB and 840MB.

We have done some checking on the Live system and it looks like something happens each time we log in.
Exactly five minutes after logging in there is an increase in the size of the hansa.hdb.
If you stay logged in to the system then no further increases happen, but if you log out and back in again there is another increase five minutes after you log in again.
So each time a user logs in, and stays logged in for more than five minutes then the client hansa.hdb increases in size. It's exactly 5 minutes after logging in that it increases, almost like something is polling.

Have you heard of anyone experiencing similar issues on different versions to the current version? The customer is mostly using Windows 10 but we are using both Windows 10 and 11 here and experiencing the same issue.
We just want to know what may be triggering it so that we can try and reduce the possibility of it happening, so any pointers as to what triggers it would be great.

Thanks

Best wishes

Dave
6-12-24
Created by16:50 11 Jun 2024
Hi again, We have a customer on version 2021-04-21. We have noticed an issue with the client hansa.hdb files increasing in size . We have seen this happening on our Windows Test Server but the customer is also now reporting the same issue on their L
Hi again,

We've been doing some investigation and we’ve identified that at the exact time the local client HDB file is increasing in size there is an entry in the local client log file that says:

“FAILED to add idle task UpdateUniversityCache because it is already running”

For the installations where the local HDB file is increasing in size, the entry in the log file only happens at the point the file size increases.

This entry also happens in the log file on installations where the local HDB file isn’t increasing in size but it may give us a pointer as to why the HDB file is increasing in size.

Have you any idea what the entry in the log file is on about and whether it’s possible to stop it trying to add to this University Cache or whether we can turn it off somehow?

Thanks

Best wishes

Dave
6-13-24
Created by16:31 12 Jun 2024
Hi again, We've been doing some investigation and we’ve identified that at the exact time the local client HDB file is increasing in size there is an entry in the local client log file that says: “FAILED to add idle task UpdateUniversityCac
Hello again,

More investigations into the growing size of the client HDB file.
We have found that the installations that have a growing client HDB file have "Using LRU Replacement" in the client log file when the client starts up. Installations that don't have the client HDB file increasing in size have "Using Clock Replacement" when SERP starts up.

It sounds like the growing client HDB file is some sort of caching issue connected with the "UpdateUniversityCache" line and "LRU Replacement" in the client log file - would that be correct?

I'm trying to think of ways to solve this, can you help please? So is there a way of either:

1. Force the client to be using "Clock Replacement" as apposed to "LRU Replacement"
2. or Turn off the University Cache
3. or both

Appreciate your help to resolve.

Thanks

Best wishes

Dave
Yavuz Yigiterhan
6-18-24
Hello. We had few sessions on this previously.

I will be forwarding your updates to our technical resources. And wil get back to you.

Thank you for updates.
Yavuz
6-25-24
Hi!

Thanks for good and detailed information!
Can you clarify, please, what exact version you are experiencing this on?
We have done some fixes to Uni cache this spring and we would suspect that the issues you are reporting should be fixed.
If you are experiencing this in a recent version, please report a bug and zip -> upload and share with us the HTB file so we could take a look.

Martins
6-26-24
Hi Martins,

We're experiencing this on version 2021-04-21 but we've only recently noticed it - I'm sure we would have noticed it before.

If you have done some work on Uni Cache in the Spring of 2024 would this affect the version 2021-04-21 that our customer is currently on? i.e. is the recent work on Uni Cache affecting a backend HansaWorld server or is this work affecting the newer version of Standard ERP?

Our current work around is to remove the offending HDB file and create a new one - is there another work around or fix for this? We're intenting to upgrade the customer later this year but would appreciate any known fixes/work arounds for their current version.

Thanks

Best wishes

Dave
6-26-24
Created by15:36 26 Jun 2024
Hi Martins, We're experiencing this on version 2021-04-21 but we've only recently noticed it - I'm sure we would have noticed it before. If you have done some work on Uni Cache in the Spring of 2024 would this affect the version 2021-
Hi again Martins,

Sorry, meant to ask, what is UniCache - is it the "University Cache" in Standard ERP that we see in the log file? - see previous messages above.

Thanks

Best wishes

Dave
6-29-24
Hey all!

Yes - we are speaking about University Cache.

And no - our spring fixes won't affect in any way customers 3 years old version - they need to update =)

Martins.
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
Andis Blicāns, Grasko
The above applies to the window when it is opened for the first time. If the window is already open and I choose Window/Restore Position, the window takes the correct position. Namely, the upper left ...
00:43 18 July 2024
Neil
Version: 2024-03-16 Server: Linux Client: MacOS Sonoma I am seeing multiple users in different locations getting logged off many times per day when idle sometimes after a few minutes of being awa...
20:09 17 July 2024