Cleaning up general objects from the database

Clean up objects such as translation memory attributes, expired sessions, or obsolete workflows by running the General Cleaner.

About this task

The General Cleaner includes several smaller cleaners and runs them at the same time, according to a schedule that you can configure. In other words, when you run the General Cleaner, you run the following smaller cleaners:
The Translation Memory Attribute Cleaner
Cleans up the custom translation memory (TM) attributes that have been removed from WorldServer. It removes unnecessary TM attribute columns from all the partitioned TM tables in the database.
The Completed Background Task Cleaner
Cleans up all the background tasks completed at least seven days ago. You can modify this interval according to your needs. For more information, please contact WorldServer support.
The Expired Sessions Cleaner
Cleans up expired sessions from the database. Every time a user logs in to WorldServer, a session is created for that user. If the session is not used for a configurable period of time, the session expires and the user must log in to the system again. You can set the session expiration time by modifying the value of the session_timeout property in the general.properties file.
The Workflow Doctor
Repairs many known types of workflow corruption.
The Term Database Attribute Cleaner
Cleans up custom attributes on term databases (TDs) that have been removed from WorldServer.
The Workflow Cleaner
Cleans up obsolete workflows that are not used by active tasks in the system. These are usually workflows that have been replaced with newer versions.

Procedure

  1. Go to Management > Administration > Garbage Collection > General Cleaner.
  2. Under Cleaner Schedule, do one of the following:
    • Select Run with General Cleaner to use the same schedule both for this cleaner and for the General Cleaner.
    • Select Set custom dates and times to specify a different schedule for this cleaner. Under Date(s), select whether you want the cleaner to run either in certain days of the week or in a specific date of a specific month, and then select the dates and times.
  3. Select Save.