One way we have seen customers reduce the size of their Documents DB is by deleting the documents just before a job completes. This will remove the document and all related data from the Documents DB. They can do this by using the Capture Delete node on a process map.
For existing jobs/documents, they could do the following to remove document data.
- Install the Kofax Repository Browser shipped with KTA 18.104.22.168. This tool will give you a visual look of your document repository structure
- Locate folders/documents that are no longer needed by KTA
- Get instance id of the folder/document
- Pass this instance id into either of the SDK methods below depending on what your deleting
**** Before performing the steps above, the customer should take full backups of the TotalAgility and TotalAgility_Documents DB ***
Once the document data is gone from the DB there’s no way to get it back. Thus, if they restart a finished job where the associated folder/document does not exist they will run into issues.
Please know in KTA 7.2 there are document retention policies. This means KTA will hold onto documents for a certain amount of time before automatically deleting them.