Cleaning up the Audit Trail Database

The audit trail database stores all process information on every piece of work that has been performed via the Infinity Process Engine. It also stores the model information, on the base of which processes are instantiated and their activities performed.

The administrator has full control over the database, so that both, the audit trail and the model information, can be deleted. This should never be done after the model has gone into production! Deleting the audit trail means deleting all the log entries defined in the Infinity Process Platform runtime environment.

Invoking the Clean up Operation

To clean up the audit trail, you can use one of the options in the Administrative Actions section of the Administration perspective launch panel.

Cleaning up the Audit Trail Database

Choose Cleanup Audit Trail Database.

Cleanup Audit Trail Database
Figure: Cleanup Audit Trail Database

Note that you need to close all open views before proceeding for audit trail database cleanup operation. If any views are open an error is displayed.


Figure: Error - Close all Open Views

Once you closed all the open views, click Cleanup Audit Trail Database. A dialog opens to confirm the deletion.


Figure: Performing a Cleanup of the Audit Trail Database

After the cleanup operation, you are logged out of the Infinity Process Platform Portal.

Note that deployed models remain in the audit trail database.

Retaining Users and Departments

Per default, users and departments are not deleted with this process. If you like to also delete all users and departments from the audit trail, de-select the Users and Departments checkbox in the Please select the information to retain section.


Figure: Option to retain Users and Departments

Retaining Business Object Instances

Per default, Business Object instances are retained and not deleted during the cleanup process. In case you like to also delete Business Object instances, deselect the Business Object Instances checkbox in the Please select the information to retain section.


Figure: Option to retain Business Object Instances

Cleaning up the Audit Trail and Model Database

To delete all audit trail and deployed model information from your currently opened audit trail database, select Cleanup Audit Trail And Model Database.

Cleanup Audit Trail and Model Database
Figure: Cleanup Audit Trail and Model Database

Note that you need to close all open views before proceeding for audit trail and model database cleanup operation.

A confirmation dialog opens to confirm the cleanup.


Figure: Performing a Cleanup of the Audit Trail and Model Database

After completing the cleanup operation, you are logged out of the Infinity Process Platform Portal.

Configuration recommended for Cleanup Operations

The cleanup of an audit trail database may take some time and requires a significant amount of rollback space in the database. In case the data should be cleaned up in your environment, it is recommended to perform this cleanup via the command line by creating a new schema and performing a new deployment of the model as this is the simplest and quickest way. Please refer to the chapter The Sysconsole Command of the Infinity Process Platform Documentation - Operation Guide The Sysconsole Command for detailed information on the appropriate commands provided by Infinity Process Platform.

Should the cleanup be performed in the Administration Perspective, please take care of the right settings for the transactions. Please note that in that case the settings remain for the whole productive operation on the application server and the database. The transaction time (for the database or the application server) should be increased for the operation. Inside the database there could exist limits as well. Here the number of objects to be deleted could be set as a limitation for the cleanup command. Please find the according hints for these settings in the documentation of the specific database you are using.