How can I automate the Database Purge and Summarize process?
I run it in 1-3 month chunks, which take roughly 30 minutes per chunk. It’s really tedious doing it in LIVE, as well as all of our test environments, since I’m afraid of kicking it off with everything checked and a cutoff with 2 years of data that will take over a day to run (and risk crashing / freezing Epicor).
It’s got the ability to save to a process set,but when I tried, it doesn’t save the checkbox for which tables to purge. It only saves the CutOff Date. only if you use Kinetic db purge, and Kinetic process set maintenance. Not Kinetic purge and classic process set maintenance.
Is it possible with Powershell somehow? Or run it via REST and I edit the cutoff dates in Notepad++?
Try it out on the api help page before getting too carried away. I tried to run Process MRP direct, but I couldn’t get it to work due to the way the processors work. Not all of the RunDirect methods work
I was hoping I could do it with Process Sets, since we could stage them in order. Run purge PartTran with a cutoff of 1/31/2021. When that finishes, run it with a 2/2/8 cutoff, etc…
Can browser automation look to see the task is complete before opening, clicking, changing dates, and clicking on submit? I’ve never tried doing this.
It’d be great for doing benchmark tests for SO Entry (it turns to a dog when there are over 20 lines for us, likely related to too many customizations getting too much external data…).
Anything you can do in the browser, browser automation can do.
It can get to be a long definition, if you are having to hop back and forth between screen but it absolutely works.
I just made an entire automated test set for a web app I was working on.
I also made a proof of concept test for Epicor.
It loads a certain SO, checks some values, print previews, goes to sys monitor and ensures it succeeded.
I would very much like to be able to override the date limitations for being able to keep your Dev environments somewhat slimmer. Anyone got any ideas to do that?
Hally - You mean override the today-18mo minimum cut-off date? That would be nice to override. Epicor’s answer will be ‘create an Ideas’… But can we override that via code? We purge all our dev/training environments to that. It’d be nice to automate a one button purge process for dev environments, though!
Update - I was able to set up a process set to purge the database! Epicor doesn’t play nice when you use the Kinetic db purge app and then open the classic process schedule app - it did not show the purge parameters properly.
Once I opened the process set in the Kinetic process set maintenance, parameters showed properly. I ran the process set, and it’s been running as intended.
To do this, create a process set (e.g. ‘Purge’), and then for each DB purge cut-off, schedule it in the Purge process set. I did mine annually for Job purge.
I’ll see if I can export a process set (from our dev environment), to use as a starting point for next year, so I don’t have to re-create this every year… I could do it in LIVE, but that scares me. Someone could accidentally run it, and our dev environments have everything purged to the 18mo cut-off, and LIVE we only purge part-trans and journal to a 3 year cut-off…
