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.

The configuration of the Cleanup Error Filesystem (automatic) server action should correspond to the configuration of the Cleanup Database (automatic). The files should be kept at least as long as the entries in the database. Sometimes, there are entries in the database that refer to a file on the error file system.