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

[Mike Rylander]

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