Clean up Queues and Results collection for Error records on Mongo DB and reduce size.

[mehtas0311]

As per design Alteryx Server retains all FAILED jobs in the Queue and Results collections even when we set the server to keep run history and results for x days

Purging records from Designer involves manual activity

Proposing the idea of purging these error records through automation script:

Step 1: Stop Alteryx Server

Step 2: Backup Mongo DB

Step 3: Replace big size files: AS_ResultsFiles.Files.bson, AS_Results.bson, AS_ResultsFiles.bson, AS_Queue.bson with Empty .bson files of same name in the backup/AlteryxService

Step 4: restore MongoDB from the backup (with the replaced files

Step 5: restart Alteryx service.

[CristonS]

hi @mehtas0311, thank you for submitting your idea to the Alteryx Ideas forum! If you haven’t yet be sure to check out our updated Submission Guidelines as well as the other product idea forums, and "Like" the ones you want to see in the product.