Scheduling Deletion of SBW Documents

SBW Documents are stored in relational databases and can grow in size over time. If the default database is used, these entries will take up a substantial amount of disk space on the enterprise server. To avoid issues like Low Disk Space error, free up some disk space by discarding old entries in the Document Tracking Database. This can be achieved by scheduling a task for purging old SBW document records from the database. 

This feature is available in Fiorano 10.2.0 and higher versions.

User can enable the task using the Fiorano Dashboard or through eStudio.

Login to Fiorano Dashboard and perform the following actions:

1. Go to DOCUMENT TRACKING > Configuration > Miscelleanous
2. In the purge old docs dialog box, enter the following values:
   1. Schedule first purge after (HH:mm:ss): Time at which the task would execute; in HH:mm:ss format.
   2. Purge time interval (in hours): Interval at which task of deleting docs would execute.
   3. Age of Documents to purge (in days): Documents older than this value will be deleted..
3. Click Enable.
   

   

Using eStudio

Open eStudio and perform the following actions:

1. Open Profile Management perspective.

2. In the Profile Manager, open FES Profile and go to Fiorano > Esb > Sbw > SBWManager and select the EnablePurgeOldDocs check box.

   

   Stop the Enterprise Server if it is running so that you can select the particular option.

3. Enter the PurgeThreadTimeInterval, AgeOfDocs, SpecificTimeToPurge values. Description of these properties are the same as that of the corresponding elements in the purge old Docs dialog box explained in the Dashboard section.
   
   

   

4. Save the profile. 

5. Start the server to get the task enabled. 

   

   To disable the task, clear the EnablePurgeOldDocs check box.

Through Dashboard, you can enable/disable the task without stopping the server.

Clearing ESB Server Database

Old entries in the Document Tracking Database may be discarded by clearing the ESB Server Database as well.

Refer the sections below:

Refer to the Clearing ESB Server Database section for information on deleting the data present in various profiles of Enterprise Server.

In case of H2 database, SBW documents can be manually cleared by deleting the EnterpriseServers/{profile_name}/doctracking_db folder inside runtimedata directory. The server needs to be restarted after performing this action.

Please note that Fiorano recommends taking guidance from the Fiorano Technical Support Team before the manual intervention.