[OPEN-ILS-GENERAL] Reports Troubleshooting

[Ben Shum]

Hi Geoff,

I think killing clark-kent is a bit brute force, but I've done it myself 
on a few occasions for bad runaway reports.

I'd also suggest a look over 
http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells#cancel_query_report 
to see how one would cancel a report from the database side of things.

I also use SELECT * FROM reporter.currently_running; to see what reports 
are holding up the line too.

-- Ben

On 11/15/2012 03:45 PM, Geoff Sams wrote:
> My library is having trouble with the reports interface.  It seems 
> like something may have clogged up our system somehow and now reports 
> are not running.  I've restarted the service and made sure that it is 
> running properly but reports are still not running.  I figured at this 
> point the best action would be to purge pending reports?  I'm not 
> really sure how to go about that from the system as asking everyone to 
> delete pending reports would take far too long and be very 
> unpredictable.  Any assistance on this matter would be greatly 
> appreciated!
>
> Thanks,
> Geoff Sams
>
> Roanoke Public Library
> 817-491-2691
>

-- 
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20121115/fc9b726c/attachment.htm>