[OPEN-ILS-DEV] Re: Import causing staff client error

[Dan Scott]

2008/6/4 Robert <glibrarysystem at gmail.com>:
> Ok, I am able to authenticate now but I get this error as soon as I login,
> before the main screen shows up:
> * Fix Me *
> Error parsing JSON [SyntaxError: missing } after property list]
> {"payload":[],"debug": "osrfMethodException :  *** Call to
> [open-ils.circ.survey.retrieve.required] failed for session
> [1212586359.507179.12125863592968], thread trace [1]:\n  * ! EXCEPTION ! *
> \nTYPE: OpenSRF::EX::ERROR\nMess: System ERROR \nMess: Call to
> open-ils.storage for method open-ils.storage.action.survey.required.atomic
> \nMess:  failed with exception:   * ! EXCEPTION ! * \nMess: TYPE:
> OpenSRF::EX::ERROR\nMess: Mess: System ERROR \nMess: Mess:   * ! EXCEPTION !
> * \nMess: Mess: TYPE: OpenSRF::DomainObject::oilsMethodException\nMess:
> Mess: Mess: <500>   *** Call to
> [open-ils.storage.action.survey.required.atomic] failed for session
> [1212586359.522982483.10382594472], thread trace [1]:\nMess: Mess: Mess:
> DBD::Pg::st execute failed: no connection to the server\nMess: Mess: Mess:
> [for Statement \"\t\tSELECT\ts.*\nMess: Mess: Mess: \t\t
> FROM\taction.survey s\nMess: Mess: Mess: \t\t  \tJOIN
> actor.org_unit_full_path(?) p ON (p.id = s.owner)\nMess: Mess: Mess: \t\t
> WHERE\tCURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date\nMess: Mess:
> Mess: \t\t  \tAND s.required IS TRUE;\nMess: Mess: Mess: \" with
> ParamValues: 1='4'] at /usr/share/perl5/DBIx/ContextualFetch.pm line
> 52.\nMess: Mess: Mess: \nMess: Mess: \nMess: Mess: Loc.: 996
> OpenSRF::AppRequest \nMess: Mess: Loc.:
> /openils/lib/perl5/OpenSRF/AppSession.pm \nMess: Mess: Time: Wed Jun  4
> 09:32:39 2008\nMess: \nMess: Loc.: 162 OpenILS::Application::AppUtils
> \nMess: Loc.: /openils/lib/perl5/OpenILS/Application/AppUtils.pm \nMess:
> Time: Wed Jun  4 09:32:39 2008\nMess:  : \nLoc.: 185 OpenSRF::Application
> \nLoc.: /openils/lib/perl5/OpenSRF/Application.pm \nTi,"status":500}

The key string in this output is:

"""
DBD::Pg::st execute failed: no connection to the server
"""

Sounds like your database connection is failing (bad username/password
in one of the sections in opensrf.xml perhaps?).

-- 
Dan Scott
Laurentian University