We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

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 Community Team
Alteryx Community Team

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.