Kofax Capture - Manual (Page 41)

Operation and Maintenance
Kofax Reporting Administrator's Guide 41
Reactivating Messages
Manual reactivating is usually not necessary.
1 Start WSA Receiver Monitor from the Kofax Reporting group in the Windows Start
menu.
2 Click Outbound > Active to display a list of messages.
3 Optionally, select multiple messages.
4 Click Reactivate.
Manual reactivating in WSA Sender is not practical, retries are performed very fast.
Deleting Old Data from Warehouse Database
After few months or years, customers may decide to purge old reporting data from the
database, because it is no longer needed. This deletion is performed by running a database
script (a stored procedure called sp_delete_hist_oper_data).
1 Stop the ETL Agent service.
2 Log on to a database management tool, e.g. Microsoft SQL Server Management Studio or
Oracle SQL Developer.
3 Run the stored procedure, e.g. for MS SQL:
sp_delete_hist_oper_data 10000, 2011, 11
This example deletes all data older than 1 November 2011, 00:00:00.
For Oracle:
CALL sp_delete_hist_oper_data(10000, 2011, 11)
4 Restart the ETL Agent afterwards.
Deleting data from the database can be a time-consuming operation (especially in Oracle
databases). Updating table and index statistics before deleting might improve the delete
performance:
EXEC dbms_stats.gather_schema_stats('schema_name', cascade=>TRUE);
The table etl_job_details is not managed by this stored procedure. This table contains log
entries for diagnostics; administrators can truncate it manually if needed.
Deleting Old Data from Staging Database
The reporting data in the staging database is managed automatically. By default, processed
records are deleted immediately. This can be changed by editing the ETL Agent advanced
configuration (refer to Configuring Advanced Settings of ETL Agent ). Exception: The
Workstation table is not deleted.