Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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

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.

1 Comment
CristonS
Alteryx Alumni (Retired)

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