18.02.2025
11:46
Hello,
we have a huge AdminServiceLog table in the BPS_Config db that is constantly growing. Is it possible to archive or delete these records without causing side effects?
Are there further optimization possibilities to avoid large data records in advance or to adjust them afterwards?
18.02.2025
15:27
Hi Celina,
did you configure the database maintenance hours? The tables should be cleared up during this time.
Best regards,
Daniel
19.02.2025
09:45
Hi Celina,
did you configure the database maintenance hours? The tables should be cleared up during this time.
Best regards,
Daniel
Hi Daniel,
thank you for your answer, we do have configured these settings.
Are there other possibilities?
19.02.2025
15:07
Hi Daniel,
thank you for your answer, we do have configured these settings.
Are there other possibilities?
Hi Celina,
since the records should be cleared by the system after 30 days, it should be fine to delete them.
Did you check whether you have more than 100,000 entries in this table?
If this is the case, then the whole maintenance mode is not working well. Maybe the time window is to small and therefore the table doesn't get cleaned up.
Best regards,
Daniel
19.02.2025
15:26
Hi Celina,
since the records should be cleared by the system after 30 days, it should be fine to delete them.
Did you check whether you have more than 100,000 entries in this table?
If this is the case, then the whole maintenance mode is not working well. Maybe the time window is to small and therefore the table doesn't get cleaned up.
Best regards,
Daniel
The time window was set to half an hour - I have now increased it and will see tomorrow if anything has changed.
Thanks for the tip!
25.02.2025
13:01
The time window was set to half an hour - I have now increased it and will see tomorrow if anything has changed.
Thanks for the tip!
Hi,
an half an hour should be enough for most installations.
I suspect that clearing logs causes errors -> in that situation system write every second error info to AdminService Log table... and unable to clear it.
Check system logs in service hours.
