[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