Gentran:Server for Windows - How to delete a large number of documents from the ?Out Documents

Body

How to delete a large number of documents from the ?Out Documents.

Potential scenario: a map is caught in an infinite loop and creates thousands of documents in the ?Out Documents.

Cannot delete a large number of documents from the ?Out Documents and GENTRAN is not responding when trying to delete the documents from the ?Out Documents.  If manually deleting the documents fails, run a DELETE query to clear the documents from the system.

To remove all the documents from the ?Out Documents, run the following query:

SQL:
DELETE FROM Document_tb where LocationStaus=5

Oracle:
DELETE FROM "Document_tb" where "LocationStatus" = 5;

Subsequently, run GiCheck to remove the orphaned files created by the query.

This should be done with the services stopped and a backup of the database and GENSRVNT directory in place.