Skip to main content

Kofax TotalAgility71 - How we can delete or reduce the size of the Documents DB?

Article # 301947 - Page views: 707

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.

  1. Install the Kofax Repository Browser shipped with KTA  This tool will give you a visual look of your document repository structure
  2. Locate folders/documents that are no longer needed by KTA
  3. Get instance id of the folder/document
  4. Pass this instance id into either of the SDK methods below depending on what your deleting
    1. CaptureDocumentService.DeleteFolder
    2. CaptureDocumentService.DeleteDocument


**** 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.