Re: [OPEN-ILS-GENERAL] Reporting module appears stuck

2019-06-02 Thread JonGeorg SageLibrary
Ok, thank you. Our old internal documentation was incomplete. I will be adding what you’ve provided for next time a report gets stuck. I made a typo in testing for stuck reports, your sql queries worked like a charm - thank you. Truly. Have a fabulous day. -Jon On Sun, Jun 2, 2019 at 12:08 PM Jaso

Re: [OPEN-ILS-GENERAL] Reporting module appears stuck

2019-06-02 Thread Jason Stephenson
At this point, you are beyond my knowledge of the reporter. However, it sounds like you stopped two reports while they were running. That's generally not a good idea. On 6/2/19 1:21 PM, JonGeorg SageLibrary wrote: > Thank you so much for responding and that script is essentially what I > was loo

Re: [OPEN-ILS-GENERAL] Reporting module appears stuck

2019-06-02 Thread JonGeorg SageLibrary
Thank you so much for responding and that script is essentially what I was looking for, as I knew there had to be a way to view stuck reports. The first time I ran *pgrep -af Clark* it returned 2 report names. However, since restarting Clark that first time after killing those two processes I get

Re: [OPEN-ILS-GENERAL] Reporting module appears stuck

2019-06-02 Thread Jason Stephenson
I sounds like you have dead reports that are preventing new reports from starting. When a report dies or is killed, they aren't cleaned up and Clark will think that they are still running. First, check if Clark is running and running any reports: pgrep -af Clark If you run that on the serve