search

gwu-libraries / launchpad

A django based system that provides a stable URL for every item in the library's catalog. Various discovery services will link to these URLs. The page for each item will in turn link out to various other resources that provide methods for accessing the content of the items.
MIT License
15 stars 9 forks source link

ignore duplicate OCLC value (OCoLC)eebo #1187

Closed cummingsm closed 7 years ago

cummingsm commented 7 years ago

There are 46,799 records in Voyager that were loaded from GT where the load process created the same 035$a value: "(OCoLC)eebo".

If a user attempts to access one of the bib records launchpad will trigger the error "DatabaseError: ORA-01795: maximum number of expressions in a list is 1000"

An example is bibid 6945932, the GT record is http://catalog.library.georgetown.edu/record=b3143765~S4

I posted a request to WRLC to delete the duplicate 035$a values (WRLC ticket 15998). If the WRLC cannot fix the data, a step will need to be added to launchpad to ignore those values when looking up related records by OCLC number.

cummingsm commented 7 years ago

WRLC removed GT eebo records from WRLC Voyager.

cummingsm commented 7 years ago

Now there are 57,000 GT records having the 035@a value "(OCoLC)mome". Awaiting WRLC response to my request to fix them... eg. 6722935

cummingsm commented 7 years ago

WRLC fixed the data.