Automatic database cleanup of asset history
Why is my asset history cleaned up without further notice?
The Cleanup Database (automatic) server action has the task to clean up older events, messages, and asset history entries from the respective database tables. A bug fix resolves the situation that the server action was activated but the respective parameters were not activated.
Availability of the bug fix
The bug fix is available for the following censhare releases and higher:
2019.2.0
2019.1.0
2018.3.4
2018.2.5
2018.1.6
2017.5.14
2017.4.12
Situation
The Cleanup Database (automatic) server action started to delete older events, messages, and asset history entries from the database. I did not activate or configure this server action. Why is this happening?
What has happened
The Cleanup Database (automatic) server action has several parameters that define how long the action s[OK1] should keep certain entries for messages, events, and asset history in the database. These parameters have been activated as part of a bug fix.
The Cleanup Database (automatic) server action has already been activated for some time as part of the censhare standard. From this point on, the server action has been executed. However, the execution did not take any effect as the parameters were not activated by default.
With the bug fix, the Cleanup Database (automatic) server action now works as intended.
What is the function of the server action
censhare creates events, messages and entries for the asset history regularly. This information is stored in three database tables:
event_task
message
log_history
The size of these tables increases over time. This leads to database performance problems if a system has been running for a longer time.
The Cleanup Database (automatic) server action prevents this by removing older entries regularly. For this reason, the server action is activated by default.
If it is crucial for customers to store the information, they can adapt the server action to their needs at their own risk.
You find the server action in the censhare Admin Client in the Cleanup folder in Configuration/Modules/Administration.