[OPEN-ILS-GENERAL] Reshelving 2.2Alpha1

[Ben Shum]

Hi Sue,

Not sure about the cause of the error you're seeing quite yet, but I 
noticed that the SQL function specified as part of the error looks out 
of date.  The reshelving interval in 2.x was not picking up the proper 
values from the library settings, so with help, I managed to write a fix 
to that SQL function to get it working better.  See: 
http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=c1202c1492a210ea51610a164d938faef4a4d28c

Normally, what I would expect to see is that one would run the 
"reshelving_complete.srfsh" script at various intervals using cron, and 
then assign in the staff client a unique (or shared) library setting for 
"Change reshelving status interval".  On our system, we chose a value 
like "1 hour".   That way we don't have to specify the interval as part 
of the command actions.

Even before we made that previously mentioned change to our production 
systems, the cron job was working fine, so I'm unsure why you've 
experienced the error you've noted...

-- Ben

On 1/25/2012 8:09 AM, Sue Hopkins wrote:
>
> Hi,
>
> I am running release 2.2-alpha1 and I cannot get any reshelving to 
> work.  When I try to run the reshelving command from an srfsh prompt , 
> I get the following:
>
> srfsh# request open-ils.storage 
> open-ils.storage.action.circulation.reshelving.complete "2h"
>
> Received Exception:
>
> Name: osrfMethodException
>
> Status:  *** Call to 
> [open-ils.storage.action.circulation.reshelving.complete] failed for 
> session [1327496758.265765.13274967589115], thread trace [1]:
>
> DBD::Pg::st execute failed: called with 3 bind variables when 1 are 
> needed [for Statement "             UPDATE  asset.copy
>
>                   SET   status = 0
>
>                   WHERE id IN (
>
>             SELECT cp.id
>
>             FROM  asset.copy cp
>
>                 LEFT JOIN actor.org_unit_setting setting
>
>                     ON (cp.circ_lib = setting.org_unit AND 
> setting.name = 'circ.reshelving_complete.interval')
>
>             WHERE cp.status = 7
>
>                 AND cp.status_changed_time < NOW() - CAST( COALESCE( 
> BTRIM( setting.value,'"' ), ? )  AS INTERVAL)
>
>                   )
>
> " with ParamValues: 1=undef] at 
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
>
> Status: 500
>
> ------------------------------------
>
> Request Completed Successfully
>
> Request Time in seconds: 0.063729
>
> ------------------------------------
>
> :
>
> Any ideas how I can get this working?
>
> */Sue Hopkins/*
>
> graphic
>
> 	
>
> */Systems & Networking Manager/*
>
> /C/W MARS, Inc./
>
> /67 Millbrook Street, Suite 201/
>
> /Worcester, MA 01606/
>
> /Ph:   (508)-755-3323 *ext-18*/
>
> /Fax: (508)-755-3721/
>

-- 
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/20120125/f994334c/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3714 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120125/f994334c/attachment.jpeg>