oils_xpath invalid xpath expression in acquisitions record upload

Bug #1442752 reported by Jason Stephenson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Invalid
Undecided
Unassigned

Bug Description

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.

Revision history for this message
Mike Rylander (mrylander) wrote :

It means that one of the following tables has a bad xpath value:

acq.lineitem_generated_attr_definition
acq.lineitem_marc_attr_definition
acq.lineitem_provider_attr_definition

Most likely are the marc and provider tables.

HTH.

Revision history for this message
Jason Stephenson (jstephenson) wrote :

Mike,

Thanks!

Looks like it is in acq.lineitem_provider_attr_definition.

Guess we'll close this one in a bit.

Changed in evergreen:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.