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

[Robert]

All of that information is still the same. I restarted all of the services
again, including postgres and still got the same result. The username,
password and database name are matched up between the database and the
opensrf.xml file. I restarted once again, just the evergreen services and it
worked fine. I'm not sure why that is but anyway, it's working again. I'm
not sure why I'm having such a hard time with the imports. Maybe I'll just
use the gutenberg way and just add the copies and volumes in manually.
Thanks for the help Dan.

On Wed, Jun 4, 2008 at 10:06 AM, Dan Scott <denials at gmail.com> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080604/084e3a6f/attachment.html