Tim, FWIW, I’ve implemented a method which issues a resume process command for each of my stored procedures. I invoke it via a new process command using the On Backup Shutdown command. My backups run once per day so it gives me a clean way of resuming those procedures each day after the backup completes. If they aren’t stuck then no big deal. If they are then they get resumed. Once completed the process dies. It was the best solution I could come up with for a work around until the problem is fixed.
Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Oct 25, 2017, at 4:13 PM, Tim Nevels via 4D_Tech <[email protected]> > wrote: > > > I’m a big user of Stored Procedure and I don’t need the headache of them > acting up when everything is completely stable now. And it’s a bug I can’t > even implement a work around for, other than to manually monitor all server > every single day and executing RESUME PROCESS commands manually when I detect > an issue. I’ve got work to do. I’m not going to become a server babysitter. > This email was sent to [email protected] (mailto:[email protected]) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319&id=4e524469ed2e48cc8bc6c3810ba1273b.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D&r=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
