Evergreen Version 2.7.1, basically.
OpenSRF 2.4
Postgresql 9.1.x
Ubuntu 12.04
When trying to load a file of marc records from a vendor via acquisitions Load MARC Order Records, one of our libraries got a database error.
Checking the Postgres logs I found the following:
2015-04-10 12:32:12 EDT ERROR: invalid XPath expression
2015-04-10 12:32:12 EDT DETAIL: Invalid expression
2015-04-10 12:32:12 EDT CONTEXT: SQL function "oils_xpath" statement 1
PL/pgSQL function "oils_xpath_table" line 54 at FOR over EXECUTE statement
PL/pgSQL function "extract_marc_field_set" line 6 at FOR over SELECT rows
SQL function "extract_acq_marc_field_set" statement 1
PL/pgSQL function "ingest_acq_marc" line 43 at FOR over SELECT rows
2015-04-10 12:32:12 EDT STATEMENT: INSERT INTO acq.lineitem (id,selector,picklist,purchase_order,provider,create_time,edit_time,marc,eg_bib_id,source_label,expected_recv_time,state,creator,editor,claim_policy,cancel_reason,estimated_unit_price,queued_record) VALUES (DEFAULT,883625,DEFAULT,746,5,'now','now','<record xmlns:xsi="http://www.w3.org/2001/XMLSche ma-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/m arcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim "><leader>01482ngm a22003732a 4500</leader><controlfield tag="001">MWT11280147</controlfield><controlfield tag="003">MWT</controlfield><controlfield tag="005">20150410040449.1</controlfield><controlfield tag="007">vd cvaizs</controlfield><controlfield tag="008">150410s2015 xxu093 j vleng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a"></subfield><subfield code="c">$29.99</subfield></datafield><datafield tag="024" ind1="1" ind2=" "><subfield code="a">032429217295</subfield></datafield><datafield tag="028" ind1="4" ind2="2"><subfield code="a">11280147</subfield></datafield><datafield tag="245" ind1="0" ind2="0"><subfield code="a">SPONGEBOB MOVIE, THE - SPONGE OUT OF WATER</subfield><subfield code="h">[videorecording].</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Widescreen ed.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">[United States] :</subfield><subfield code="b">Paramount,</subfield><subfield code="c">2015.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 videodisc (ca. 93 min.) :</subfield><subfield code="b">sd., col. ;</subfield><subfield code="c">4 3/4 in.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">06/02/2015</subfield></datafield><datafield tag="508" ind1="1" ind2=" "><subfield code="a">Director, Paul Tibbitt.</subfield></datafield><datafield tag="511" ind1="1" ind2=" "><subfield code="a">Tom Kenny, Antonio Banderas, Bill Fagerbakke, Tim Conway.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">When pirate Burger Beard steals the secret recipe for the beloved Krabby Patties, SpongeBob and friends come ashore to bring back the missing formula. To succeed, they must team up with former rival, Plankton, but soon realize that to defeat a super-villain, they must unleash their inner superheroes.</subfield></datafield><datafield tag="521" ind1="8" ind2=" "><subfield code="a">MPAA rating: PG.</subfield></datafield><datafield tag="538" ind1=" " ind2=" "><subfield code="a">DVD.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English, French, Spanish audio; English, French, Portuguese, Spanish subtitles.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Children''s films.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Animated.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Family Films.</subfield></datafield><datafield tag="655" ind1=" " ind2="4"><subfield code="a">Children''s.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kenny, Tom</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Banderas, Antonio</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Fagerbakke, Bill</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Conway, Tim</subfield></datafield><datafield tag="856" ind1="7" ind2=" "><subfield code="3">View cover art</subfield><subfield code="u">http://midwesttapes.com/images /movies/000/000/000/011/280/00 0000000011280147.jpg</subfield><subfield code="2">http</subfield></datafield><datafield tag="962" ind1=" " ind2=" "><subfield code="r">22.99</subfield><subfield code="u">DVD</subfield><subfield code="b">MLI</subfield><subfield code="o">1</subfield></datafield></record>',DEFAULT,'MWT',DEFAULT,'pending-order',883625,883625,DEFAULT,DEFAULT,DEFAULT,DEFAULT);
I've looked and the database functions concerned and can't make heads or tails out this situation.
It means that one of the following tables has a bad xpath value:
acq.lineitem_ generated_ attr_definition marc_attr_ definition provider_ attr_definition
acq.lineitem_
acq.lineitem_
Most likely are the marc and provider tables.
HTH.