[OPEN-ILS-DEV] Getting errors looking up patrons, and most items

Hunt, Phil hunt at nelinet.net
Thu Jun 25 10:56:03 EDT 2009 

I have a test Evergreen, 1.4.0.4

I added a few branches, that seems ok:
opensrf at LNXEVG1OS1:/openils/bin$ ./autogen.sh -c
/openils/conf/opensrf_core.xml -u
Updating fieldmapper
Updating web_fieldmapper
Updating OrgTree
removing OrgTree from the cache for locale hy-AM...
removing OrgTree from the cache for locale cs-CZ...
removing OrgTree from the cache for locale en-CA...
removing OrgTree from the cache for locale en-US...
removing OrgTree from the cache for locale fr-CA...
Updating OrgTree HTML
Updating locales selection HTML
Updating Search Groups
Refreshing proximity of org units
Successfully updated the organization proximity
Done


Added a few patrons.  Looking them up seems to only work by barcode.

Any other gives 'Multiple row' errors:
Network or server failure.  Please check your Internet connection to
evergreen.nelinet.net and choose Retry Network.  If you need to enter
Offline Mode, choose Ignore Errors in this and subsequent dialogs.  If
you believe this error is due to a bug in Evergreen and not network
problems, please contact your help desk or friendly Evergreen
administrators, and give them this information:
method=open-ils.actor.patron.search.advanced
params=["fa99f756295d2e333c066af668027618",{"family_name":{"value":"hunt
","group":0}},51,["family_name ASC","first_given_name
ASC","second_given_name ASC","dob DESC"],1,"2"]
THROWN:
{"message":"missing } after property
list","fileName":"http://evergreen.nelinet.net/opac/common/js/JSON_v1.js
","lineNumber":14,"stack":"JSON2jsRaw()@:0\neval(\"obj =
{\\\"payload\\\":[],\\\"debug\\\": \\\"osrfMethodException :  *** Call
to [open-ils.actor.patron.search.advanced] failed for session
[1245941484.103310.124594148431045], thread trace [1]:\\\\nException:
OpenSRF::EX::ERROR 2009-06-25T10:51:24 OpenSRF::Application
/usr/local/share/perl/5.10.0/OpenSRF/Application.pm:202 System ERROR:
Call to open-ils.storage for method
open-ils.storage.actor.user.crazy_search \\\\n failed with exception:
Exception: OpenSRF::EX::ERROR 2009-06-25T10:51:24
OpenILS::Application::AppUtils
/openils/lib/perl5/OpenILS/Application/AppUtils.pm:179 System ERROR:
Exception: OpenSRF::DomainObject::oilsMethodException
2009-06-25T10:51:24 OpenSRF::AppRequest
/usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500>   *** Call
to [open-ils.storage.actor.user.crazy_search] failed for session
[1245941484.129163860.90797373766], thread trace [1]:\\\\nDBD::Pg::db
selectcol_arrayref failed: ERROR:  more than one row returned by a
subquery used as an expression\\\\nCONTEXT:  SQL function
\\\\\\\"org_unit_descendants\\\\\\\" statement 1 [for Statement
\\\\\\\"\\\\t\\\\tSELECT\\\\tDISTINCT LOWER(users.family_name),
LOWER(users.first_given_name), LOWER(users.second_given_name),
LOWER(users.dob), LOWER(users.id)\\\\n\\\\t\\\\t  FROM\\\\tactor.usr AS
users\\\\n\\\\t\\\\t\\\\tJOIN (SELECT id as id FROM actor.usr u WHERE
LOWER(family_name) ~ ?) AS search ON (search.id =
users.id)\\\\n\\\\t\\\\t\\\\tJOIN actor.org_unit_descendants(4, 2) d ON
(d.id =
users.home_ou)\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t
WHERE\\\\tusers.deleted =
FALSE\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t  ORDER BY
LOWER(users.family_name) ASC, LOWER(users.first_given_name) ASC,
LOWER(users.second_given_name) ASC, LOWER(users.dob) DESC,
LOWER(users.id) \\\\n\\\\t\\\\t  LIMIT 51\\\\n\\\\\\\"] at
/openils/lib/perl5/OpenILS/Application/Storage/Publ,\\\"status\\\":500}\
")@:0\nJSON2jsRaw(\"{\\\"payload\\\":[],\\\"debug\\\":
\\\"osrfMethodException :  *** Call to
[open-ils.actor.patron.search.advanced] failed for session
[1245941484.103310.124594148431045], thread trace [1]:\\\\nException:
OpenSRF::EX::ERROR 2009-06-25T10:51:24 OpenSRF::Application
/usr/local/share/perl/5.10.0/OpenSRF/Application.pm:202 System ERROR:
Call to open-ils.storage for method
open-ils.storage.actor.user.crazy_search \\\\n failed with exception:
Exception: OpenSRF::EX::ERROR 2009-06-25T10:51:24
OpenILS::Application::AppUtils
/openils/lib/perl5/OpenILS/Application/AppUtils.pm:179 System ERROR:
Exception: OpenSRF::DomainObject::oilsMethodException
2009-06-25T10:51:24 OpenSRF::AppRequest
/usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500>   *** Call
to [open-ils.storage.actor.user.crazy_search] failed for session
[1245941484.129163860.90797373766], thread trace [1]:\\\\nDBD::Pg::db
selectcol_arrayref failed: ERROR:  more than one row returned by a
subquery used as an expression\\\\nCONTEXT:  SQL function
\\\\\\\"org_unit_descendants\\\\\\\" statement 1 [for Statement
\\\\\\\"\\\\t\\\\tSELECT\\\\tDISTINCT LOWER(users.family_name),
LOWER(users.first_given_name), LOWER(users.second_given_name),
LOWER(users.dob), LOWER(users.id)\\\\n\\\\t\\\\t  FROM\\\\tactor.usr AS
users\\\\n\\\\t\\\\t\\\\tJOIN (SELECT id as id FROM actor.usr u WHERE
LOWER(family_name) ~ ?) AS search ON (search.id =
users.id)\\\\n\\\\t\\\\t\\\\tJOIN actor.org_unit_descendants(4, 2) d ON
(d.id =
users.home_ou)\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t
WHERE\\\\tusers.deleted =
FALSE\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t  ORDER BY
LOWER(users.family_name) ASC, LOWER(users.first_given_name) ASC,
LOWER(users.second_given_name) ASC, LOWER(users.dob) DESC,
LOWER(users.id) \\\\n\\\\t\\\\t  LIMIT 51\\\\n\\\\\\\"] at
/openils/lib/perl5/OpenILS/Application/Storage/Publ,\\\"status\\\":500}\
")@http://evergreen.nelinet.net/opac/common/js/JSON_v1.js:14\nJSON2js(\"
{\\\"payload\\\":[],\\\"debug\\\": \\\"osrfMethodException :  *** Call
to [open-ils.actor.patron.search.advanced] failed for session
[1245941484.103310.124594148431045], thread trace [1]:\\\\nException:
OpenSRF::EX::ERROR 2009-06-25T10:51:24 OpenSRF::Application
/usr/local/share/perl/5.10.0/OpenSRF/Application.pm:202 System ERROR:
Call to open-ils.storage for method
open-ils.storage.actor.user.crazy_search \\\\n failed with exception:
Exception: OpenSRF::EX::ERROR 2009-06-25T10:51:24
OpenILS::Application::AppUtils
/openils/lib/perl5/OpenILS/Application/AppUtils.pm:179 System ERROR:
Exception: OpenSRF::DomainObject::oilsMethodException
2009-06-25T10:51:24 OpenSRF::AppRequest
/usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500>   *** Call
to [open-ils.storage.actor.user.crazy_search] failed for session
[1245941484.129163860.90797373766], thread trace [1]:\\\\nDBD::Pg::db
selectcol_arrayref failed: ERROR:  more than one row returned by a
subquery used as an expression\\\\nCONTEXT:  SQL function
\\\\\\\"org_unit_descendants\\\\\\\" statement 1 [for Statement
\\\\\\\"\\\\t\\\\tSELECT\\\\tDISTINCT LOWER(users.family_name),
LOWER(users.first_given_name), LOWER(users.second_given_name),
LOWER(users.dob), LOWER(users.id)\\\\n\\\\t\\\\t  FROM\\\\tactor.usr AS
users\\\\n\\\\t\\\\t\\\\tJOIN (SELECT id as id FROM actor.usr u WHERE
LOWER(family_name) ~ ?) AS search ON (search.id =
users.id)\\\\n\\\\t\\\\t\\\\tJOIN actor.org_unit_descendants(4, 2) d ON
(d.id =
users.home_ou)\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t
WHERE\\\\tusers.deleted =
FALSE\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t\\\\t\\\\n\\\\t\\\\t  ORDER BY
LOWER(users.family_name) ASC, LOWER(users.first_given_name) ASC,
LOWER(users.second_given_name) ASC, LOWER(users.dob) DESC,
LOWER(users.id) \\\\n\\\\t\\\\t  LIMIT 51\\\\n\\\\\\\"] at
/openils/lib/perl5/OpenILS/Application/Storage/Publ,\\\"status\\\":500}\
")@http://evergreen.nelinet.net/opac/common/js/JSON_v1.js:9\n()@http://e
vergreen.nelinet.net/opac/common/js/RemoteRequest.js:319\n([object
Object])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.j
s:250\n(\"open-ils.actor\",\"open-ils.actor.patron.search.advanced\",[ob
ject Array],[object Object],undefined,[object
Object])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.j
s:379\n(\"open-ils.actor\",\"open-ils.actor.patron.search.advanced\",[ob
ject Array],undefined,undefined,[object
Object])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.j
s:362\n(\"open-ils.actor\",\"open-ils.actor.patron.search.advanced\",[ob
ject Array],undefined,undefined,[object
Object])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.j
s:277\n(\"FM_AU_IDS_RETRIEVE_VIA_HASH\",[object
Array])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.js
:239\n([object
Object])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.j
s:397\n([object
Object])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/main/JSAN.j
s:337\nmy_init()@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/pat
ron/search_result.xul:36\nonload([object
Event])@http://evergreen.nelinet.net/xul/rel_1_4_0_4/server/patron/searc
h_result.xul:1\n@:0\n","name":"SyntaxError"}



Any ideas where to look?

Thanks all

 
Phil Hunt
Program Director, Information Technology
NELINET, Inc.
 
'   Direct Phone:  (508)597-1924
'    1.508.460.7700 x1924
6     FAX (508)460-9455
* hunt at NELINET.net

More information about the Open-ils-dev mailing list