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

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

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

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