topic Re: Delete or Modify Mongodb records in Alteryx Server Discussions

Delete or Modify Mongodb records

nraghavak — Tue, 03 May 2022 16:31:02 GMT

Hi,

I need to take a backup of Prod data into another test environment but i do not want those schedules to run again on test. And i use embedded mongodb as part of server installation.

Hence intending to delete these copied schedules from mongodb on test environment before making test server live, whether anyone has played by doing any alterations to mongo db and how was your experience?

Also you got any other recommendations on how to disable schedulers on another environment?

Thanks,

Rag

Re: Delete or Modify Mongodb records

David-Carnes — Tue, 03 May 2022 16:56:05 GMT

Hi @nraghavak!
There are two ways to do this. Before you restore from production, go into the the Alteryx System Setting and change the Worker Configuration by either
1. Unchecking the Run unasssigned jobs under Job Assignment.

2. Unchecking Allow machine to run scheduled Alteryx workflows.

https://help.alteryx.com/20214/server/worker

Hope this helps!

Best,

David

Re: Delete or Modify Mongodb records

nraghavak — Wed, 04 May 2022 00:49:01 GMT

Hi David,

Thanks for solution.

If understood correctly, uncheck these options on Prod then take a backup. After taking a backup, undo the changes in Prod. Then restore this backup data on Test?

I have tried this but this automatically get checked again while restoring on Test server?

Thanks,

Rag

Re: Delete or Modify Mongodb records

nraghavak — Wed, 04 May 2022 00:50:57 GMT

Also would like to know your experiences if you have tried to tamper embedded mongodb like updating or deleting few records etc.?

Re: Delete or Modify Mongodb records

David-Carnes — Wed, 04 May 2022 00:59:35 GMT

You need to turn off the ability to run schedules on the test box, not on production.

I have attempted to alter the MongoDB but the user account doesn't have permissions for that.

Re: Delete or Modify Mongodb records

nraghavak — Wed, 04 May 2022 01:07:31 GMT

Hi David, thanks but i need other workflows to still run as per the schedule on test. So when i checked again on test, what happens to those prod jobs on test, i do not not want them to ever run on test environment

Re: Delete or Modify Mongodb records

David-Carnes — Wed, 04 May 2022 01:19:20 GMT

Well, I usually delete all the schedules in Gallery (Admin), then go back to the server to delete all the items in the queue. (Open Designer on the test server, view schedules, queue tab. They pile up but can't run.)

In your case, delete the unwanted schedules in in Gallery, keep the ones you want, delete the items in the queue (there's a little button with a minus sign). Maybe that's what you need?