[OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade
Peters, Michael
MRPeters at library.IN.gov
Wed Nov 10 09:53:09 EST 2010
Left out second query...
evergreen=# SELECT name, prefix, namespace_uri FROM config.xml_transform;
name | prefix | namespace_uri
---------+--------+--------------------------------
marcxml | marc | http://www.loc.gov/MARC21/slim
mods | mods | http://www.loc.gov/mods/
mods32 | mods | http://www.loc.gov/mods/
mods33 | mods33 | http://www.loc.gov/mods/v3
(4 rows)
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 9:52 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade
Mike,
Thanks for the replies.
id | field_class | name | xpath | weight | format | search_field | facet_field
----+-------------+-------------+-----------------------------------------------------------------------------------------------------------------+--------+--------+--------------+-------------
1 | series | seriestitle | //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo | 1 | mods32 | t | f
2 | title | abbreviated | //mods32:mods/mods32:titleInfo[mods32:title and (@type='abbreviated')] | 1 | mods32 | t | f
3 | title | translated | //mods32:mods/mods32:titleInfo[mods32:title and (@type='translated')] | 1 | mods32 | t | f
4 | title | uniform | //mods32:mods/mods32:titleInfo[mods32:title and (@type='uniform')] | 1 | mods32 | t | f
5 | title | proper | //mods32:mods/mods32:titleInfo[mods32:title and not (@type)] | 1 | mods32 | t | f
9 | author | other | //mods32:mods/mods32:name[@type='personal']/mods32:namePart[not(../mods32:role)] | 1 | mods32 | t | f
10 | subject | geographic | //mods32:mods/mods32:subject/mods32:geographic | 1 | mods32 | t | f
11 | subject | name | //mods32:mods/mods32:subject/mods32:name | 1 | mods32 | t | f
12 | subject | temporal | //mods32:mods/mods32:subject/mods32:temporal | 1 | mods32 | t | f
13 | subject | topic | //mods32:mods/mods32:subject/mods32:topic | 1 | mods32 | t | f
14 | keyword | keyword | //mods32:mods/*[not(local-name()='originInfo')] | 1 | mods32 | t | f
15 | title | alternative | //mods32:mods/mods32:titleInfo[mods32:title and (@type='alternative')] | 1 | mods32 | t | f
6 | author | corporate | //mods32:mods/mods32:name[@type='corporate']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | 1 | mods32 | t | f
7 | author | personal | //mods32:mods/mods32:name[@type='personal']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | 1 | mods32 | t | f
8 | author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | 1 | mods32 | t | f
(15 rows)
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:46 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade
The simplest thing to do is move the offending UPDATE to the top of
the script, which I will now do. However, I suspect that you may have
mismatched registered namespace prefixes and xpath statements ... can
you reply with the output of the following sql?
SELECT * FROM config.metabib_field;
SELECT name, prefix, namespace_uri FROM config.xml_transform;
TIA
--miker
On Wed, Nov 10, 2010 at 8:52 AM, Peters, Michael
<MRPeters at library.in.gov> wrote:
> Hey all,
>
> Writing in hopes that someone else might have run into this and have some
> advice.
>
> My upgrade seems to be dying out around line 10961 of the upgrade script
> (best guess).
>
> Last few actions:
>
> create_acq_auditor
> --------------------
> t
> (1 row)
>
> CREATE INDEX
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> INSERT 0 1
> INSERT 0 1
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE VIEW
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> NOTICE: CREATE TABLE will create implicit sequence "merge_profile_id_seq"
> for serial column "merge_profile.id"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "merge_profile_pkey" for table "merge_profile"
> NOTICE: CREATE TABLE / UNIQUE will create implicit index
> "vand_merge_prof_owner_name_idx" for table "merge_profile"
> CREATE TABLE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE INDEX
> CREATE RULE
> ERROR: could not create XPath object
> DETAIL: Undefined namespace prefix
> xmlXPathCompiledEval: evaluation failed
> CONTEXT: SQL function "oils_xpath" statement 1
> PL/pgSQL function "extract_metabib_field_entry" line 36 at assignment
> SQL function "extract_metabib_field_entry" statement 1
> PL/pgSQL function "reingest_metabib_field_entries" line 14 at FOR over
> SELECT rows
> SQL statement "SELECT metabib.reingest_metabib_field_entries( $1 )"
> PL/pgSQL function "indexing_ingest_or_delete" line 34 at PERFORM
>
> Log:
>
> postgres at dev:~$ tail /var/log/postgresql/*
> 2010-11-09 16:13:33 EST ERROR: could not create XPath object
> 2010-11-09 16:13:33 EST DETAIL: Undefined namespace prefix
> xmlXPathCompiledEval: evaluation failed
> 2010-11-09 16:13:33 EST CONTEXT: SQL function "oils_xpath" statement 1
> PL/pgSQL function "extract_metabib_field_entry" line 36 at assignment
> SQL function "extract_metabib_field_entry" statement 1
> PL/pgSQL function "reingest_metabib_field_entries" line 14 at FOR over
> SELECT rows
> SQL statement "SELECT metabib.reingest_metabib_field_entries( $1 )"
> PL/pgSQL function "indexing_ingest_or_delete" line 34 at PERFORM
> 2010-11-09 16:13:33 EST STATEMENT: UPDATE biblio.record_entry SET marc =
> '<record xmlns="http://www.loc.gov/MARC21/slim"/>' WHERE id = -1;
>
> Thanks for any help anyone can provide!
>
> Sincerely,
> Michael Peters
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana
> Helpdesk
> office - 317.234.2128
> email - mrpeters at library.in.gov
>
>
>
--
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
More information about the Open-ils-dev
mailing list