[OPEN-ILS-DEV] Evergreen 1.404..Can't search for patrons, or get wierd Postgres error

[Mike Rylander]

On Fri, Jun 12, 2009 at 9:51 AM, Hunt, Phil<hunt at nelinet.net> wrote:
> It is version 1.4.0.4
>

Hrm... the multiple-rows error is suggestive of a misconfigured org
tree.  Can you post the output of the following psql commands:

SELECT * FROM actor.org_unit_type;
SELECT * FROM actor.org_unit;

TIA,

--miker

>
> 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
>
>
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Mike Rylander
> Sent: Friday, June 12, 2009 08:37 AM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Evergreen 1.404..Can't search for patrons,or get wierd Postgres error
>
> On Thu, Jun 11, 2009 at 4:31 PM, Hunt, Phil<hunt at nelinet.net> wrote:
>> I finally figured out the proglems I was having with postgres 8.2
>
> What version of Evergreen is this?
>
> --miker
>
>>
>> I added 2 patrons, 1 as a system admin, one as a std patron.  It showed
>> some relatively minor errors during the add, but I got 'User update
>> succeeded', the errors seen were like this:
>>
>> Use of uninitialized value $p[0] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>> Use of uninitialized value $p[0] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>> Use of uninitialized value $p[0] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>> Use of uninitialized value $p[0] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>> Use of uninitialized value $p[0] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>> Use of uninitialized value $p[0] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>> Argument "1244750664.98621995.466378585992" isn't numeric in numeric ne
>> (!=) at /openils/lib/perl5/OpenILS/Application/Actor.pm line 505,
>> <STDIN> line 1.
>> Argument "1244750664.98621995.466378585992" isn't numeric in numeric ne
>> (!=) at /openils/lib/perl5/OpenILS/Application/Actor.pm line 505,
>> <STDIN> line 1.
>> Use of uninitialized value $p[2] in join or string at
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
>> line1.
>>
>>
>>
>> If I do a search by barcode, they lookup fine.
>>
>> If I do a search for patron, using any patron fields, I get this in the
>> error log for actor...
>>
>> Use of uninitialized value in hash element at
>> /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm line 193, <STDIN> line
>> 1.
>> received error : service=open-ils.storage :
>> method=open-ils.storage.actor.user.crazy_search : params=$VAR1 =
>> [{'email' => {'group' => 0,'value' =>
>> 'normal at nowhere.com'}},51,['family_name ASC','first_given_name
>> ASC','second_given_name ASC','dob DESC'],1,'4','2'];
>>  Exception: OpenSRF::EX::ERROR 2009-06-11T16:24:35
>> OpenILS::Application::AppUtils
>> /openils/lib/perl5/OpenILS/Application/AppUtils.pm:178 System ERROR:
>> Exception: OpenSRF::DomainObject::oilsMethodException
>> 2009-06-11T16:24:35 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
>> [1244751875.053172252.2513939484], thread trace [1]:
>> DBD::Pg::db selectcol_arrayref failed: ERROR:  more than one row
>> returned by a subquery used as an expression
>> CONTEXT:  SQL function "org_unit_descendants" statement 1 [for Statement
>> "              SELECT  DISTINCT LOWER(users.family_name),
>> LOWER(users.first_given_name), LOWER(users.second_given_name),
>> LOWER(users.dob), LOWER(users.id)
>>                  FROM  actor.usr AS users
>>                        JOIN (SELECT id as id FROM actor.usr u WHERE
>> LOWER(email) ~ ?) AS search ON (search.id = users.id)
>>                        JOIN actor.org_unit_descendants(4, 2) d ON (d.id
>> = users.home_ou)
>>
>>                  WHERE users.deleted = FALSE
>>                  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)
>>                  LIMIT 51
>> "] at /openils/lib/perl5/OpenILS/Application/Storage/Publisher/actor.pm
>> line 572.
>>
>> Caught error from 'run' method: Exception: OpenSRF::EX::ERROR
>> 2009-06-11T16:24:35 OpenSRF::Application
>> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm:200 System ERROR:
>> Call to open-ils.storage for method
>> open-ils.storage.actor.user.crazy_search
>>  failed with exception: Exception: OpenSRF::EX::ERROR
>> 2009-06-11T16:24:35 OpenILS::Application::AppUtils
>> /openils/lib/perl5/OpenILS/Application/AppUtils.pm:179 System ERROR:
>> Exception: OpenSRF::DomainObject::oilsMethodException
>> 2009-06-11T16:24:35 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
>> [1244751875.053172252.2513939484], thread trace [1]:
>> DBD::Pg::db selectcol_arrayref failed: ERROR:  more than one row
>> returned by a subquery used as an expression
>> CONTEXT:  SQL function "org_unit_descendants" statement 1 [for Statement
>> "              SELECT  DISTINCT LOWER(users.family_name),
>> LOWER(users.first_given_name), LOWER(users.second_given_name),
>> LOWER(users.dob), LOWER(users.id)
>>                  FROM  actor.usr AS users
>>                        JOIN (SELECT id as id FROM actor.usr u WHERE
>> LOWER(email) ~ ?) AS search ON (search.id = users.id)
>>                        JOIN actor.org_unit_descendants(4, 2) d ON (d.id
>> = users.home_ou)
>>
>>                  WHERE users.deleted = FALSE
>>                  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)
>>                  LIMIT 51
>> "] at /openils/lib/perl5/OpenILS/Application/Storage/Publisher/actor.pm
>> line 572.
>>
>> ========================================
>> So the questions are, why do I see these errors during an add?
>>
>> And 2) why does a simple lookup fail so badly....
>>
>> 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
>>
>>
>>
>
>
>
> --
> Mike Rylander
>  | VP, Research and Design
>  | Equinox Software, Inc. / The Evergreen Experts
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  miker at esilibrary.com
>  | web:  http://www.esilibrary.com
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com