[OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade

[Peters, Michael]

It would appear this is actually stemming back to aou.fiscal_calendar not existing.

I've grepped back through all of the upgrades I ran and I don't see where the creation of this should have occurred.

Sincerely, 
Michael Peters 
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128 
email - mrpeters at library.in.gov 


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Peters, Michael
Sent: Wednesday, November 10, 2010 11:01 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade

Mike,

Thanks for the update.  I completed the upgrade and was singing along until it came time to autogen.

Now I'm having some new troubles...

The logs indicate that settings is not connected, however all indications are that it is.  Everything in settings-tester.pl checks out as well.

opensrf at dev:/openils/bin$ ./autogen.sh -u
Updating Evergreen organization tree and IDL using '/openils/conf/opensrf_core.xml'

Updating fieldmapper
Updating web_fieldmapper
Updating OrgTree
removing OrgTree from the cache for locale cs-CZ...
Exception: OpenSRF::DomainObject::oilsMethodException 2010-11-10T10:53:50 OpenILS::Utils::CStoreEditor /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:409 <500>  Severe query error -- see error log for more details


osrfsys.log:[2010-11-10 10:53:28] /usr/sbin/apache2 [ERR :20899:EX.pm:66:] Exception: OpenSRF::EX::Session 2010-11-10T10:53:28 OpenSRF::Transport /usr/local/share/perl/5.10.1/OpenSRF/Transport.pm:92 Session Error: router at private.dev.evergreen.lib.in.us/opensrf.settings IS NOT CONNECTED TO THE NETWORK!!!
osrfsys.log:[2010-11-10 10:53:28] /usr/sbin/apache2 [ERR :20899:EX.pm:66:] Exception: OpenSRF::EX::Session 2010-11-10T10:53:28 OpenSRF::Utils::SettingsClient /usr/local/share/perl/5.10.1/OpenSRF/Utils/SettingsClient.pm:103 Session Error: router at private.dev.evergreen.lib.in.us/opensrf.settings IS NOT CONNECTED TO THE NETWORK!!!
osrfsys.log:open-ils.cstore 2010-11-10 10:53:50 [ERR :24013:oils_sql.c:5390:] open-ils.cstore: Error retrieving actor::org_unit with query [SELECT  "aou".billing_address, "aou".holds_address, "aou".id, "aou".ill_address, "aou".mailing_address, oils_i18n_xlate('actor.org_unit', 'aou', 'name', 'id', "aou".id::TEXT, 'cs-CZ') AS "name", "aou".ou_type, "aou".parent_ou, "aou".shortname, "aou".email, "aou".phone, "aou".opac_visible, "aou".fiscal_calendar FROM actor.org_unit AS "aou" WHERE "aou".id IS NOT NULL ORDER BY name;]: 0 ERROR:  column aou.fiscal_calendar does not exist
osrfsys.log:[2010-11-10 10:53:50] org_tree_js.pl [ERR :26794:CStoreEditor.pm:109:] editor[0|0] request error open-ils.cstore.direct.actor.org_unit.search.atomic : [{"id":{"!=":null}},{"order_by":{"aou":"name"},"no_i18n":0}] : Exception: OpenSRF::DomainObject::oilsMethodException 2010-11-10T10:53:50 OpenILS::Utils::CStoreEditor /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:396 <500>  Severe query error -- see error log for more details
osrfsys.log:[2010-11-10 10:53:50] org_tree_js.pl [ERR :26794:EX.pm:66:] Exception: OpenSRF::DomainObject::oilsMethodException 2010-11-10T10:53:50 OpenILS::Utils::CStoreEditor /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:409 <500>  Severe query error -- see error log for more details


root at dev:/openils/conf# ejabberdctl connected-users | grep settings
opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22665
opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22667
opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22669
opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22671
opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22673
opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_listener_at_dev.evergreen.lib.in.us_22656
router at private.dev.evergreen.lib.in.us/opensrf.settings


root at dev:/openils/conf# ps aux | grep settings
opensrf  22647  0.0  0.0  87068 20124 ?        Ss   10:53   0:00 OpenSRF controller [opensrf.settings]
opensrf  22654  0.0  0.0  87096 21256 ?        S    10:53   0:00 OpenSRF master [opensrf.settings]
opensrf  22656  0.0  0.0  87068 20808 ?        S    10:53   0:00 OpenSRF listener [opensrf.settings]
opensrf  22665  0.0  0.0  87380 21556 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
opensrf  22667  0.0  0.0  87372 21644 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
opensrf  22669  0.0  0.0  87096 20600 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
opensrf  22671  0.0  0.0  87372 21644 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
opensrf  22673  0.0  0.0  87372 21644 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]



Sincerely, 
Michael Peters 
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128 
email - mrpeters at library.in.gov 


-----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: Wednesday, November 10, 2010 9:59 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade

On Wed, Nov 10, 2010 at 9:56 AM, Peters, Michael
<MRPeters at library.in.gov> wrote:
> Thanks Mike!
>
> Should I continue on with the current script, or await your updated version?
>

It's in the repo now, here's the changeset:
http://svn.open-ils.org/trac/ILS/changeset/18682

-- 
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