Database size increaising exponentially
Gastón Salomone
10-14-21
Operating system: macOS
Hi

A customer has a database that is increaising size every day by a 1 or 3 GB.
I found that RecordHistory data of Items record, is enabled and every two o three seconds is storing a new update record, saying that record is updated. If I compare any of that updates against actual record, Standard ERP says that no field is updated.
The problem is that backup files is getting bigger every day.
I`m going to disable Login COntrol on that record, but I need to delete all record history information to clean and free some space while I try to find what is the problem.

How I can delete all that old data ?
While exporting a backup file, i found that RecordHistVc is increaing 5 million records every day and It get stuck in "Exporting old records" for some time, maybe 1 hour before finish backup.

I need urgent help

Please
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Carolina Valentino
are the activity set as Hansamanuals said? https://www.hansamanuals.com/main/mailnumber___62526/theconf___231/manuals/version___20250224/langcode___es/hwconvindex.htm?shortcode=HW0301SETTINGS_Order...
17:20 4 Apr 2025
Paul Timms
SendWebRequest3 is a boolean function, so if this returns true and the reply header has an accepted status, you can assume that the data was sent successfully and perform some actions on the record th...
11:12 4 Apr 2025