Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    BulkImport only deletes first holdings record

    • Product: Voyager
    • Product Version: 8.2.0

    Symptoms

    When deleting MFHDs with BulkImport, if the second MFHD found by BulkImport has no attachments, it should be deleted but is not.

    Defect Status

    VYG-4657 is resolved in Voyager 9.0.0 and higher.

    Replication Steps

    1. Create two bib records in cataloging, and add MFHDs as follows:
      1. First bib has two MFHDs, (A and B) the first with no item and the second with an item.
      2. Second bib has two MFHDS (C and D) the first with an item and the second with no item.
    2. Use MarcExport to create an interleaved file.
      1. Create a temp file with one bibID per line.
      2. Run: Pmarcexport -rG -mM -ttemp
      3. Note output filename (i.e. marc.exp.yyyymmdd.hhmm)
    3. Use BulkImport to delete the MFHDs.
      1. Run: Pbulkimport -f/m1/voyager/xxxdb/rpt/marc.exp.yyyymmdd.hhmm -iDEL -r where DEL is a BulkImport rule with Bib Dup Detection profile set to Replace on BibID and to Load Bib/Auth Only.
      2. Examine /m1/voyager/xxxdb/rpt/log.imp.yyyymmdd.hhmm
        1. Note: MFHD A is deleted (as expected), MFHD B is not (as expected)
        2. MFHD C is deleted (as expected) and MFHD D is not (not expected).

    Sample log

    I am 23370. I will be doing all of '/m1/voyager/xxxdb/rpt/marc.exp.yyyymmdd.hhmm' for you.
    The import code is "DELETE" for this run.
    The Bib dup profile is "BBID" for this run.
    The Auth dup profile is "AuthReplace" for this run.
    This import is using a rule that does not allow creation of MFHDs or Items.
    The Mfhd dup profile is "MFHD-replace" for this run.
    Expecting Marc21 UTF-8 Records
    Wed Jun 12 12:38:52 2013
    1(1):Duplicate Bibs above threshold: replace 1, warning 0.
    BibID & rank
    77524 - 100
    2(1):Duplicate Mfhds above threshold: replace 2, warning 0.
    MfhdID & rank
    76280 - 100
    76281 - 100
    MFHD 76280 deleted.
    Could not delete Mfhd 76281. There are attachments.
    Remove failed with rc=100
    3: Previous record not added.
    4(2):Duplicate Bibs above threshold: replace 1, warning 0.
    BibID & rank
    77525 - 100
    5(2):Duplicate Mfhds above threshold: replace 2, warning 0.
    MfhdID & rank
    76282 - 100
    76283 ? 100 << Should be deleted, is not.
    Could not delete Mfhd 76282. There are attachments.
    Remove failed with rc=100
    6: Previous record not added.

    BIBLIOGRAPHIC, MFHD, ITEM or AUTHORITY Records
    Processed: 2
    Added: 0
    Discarded: 0
    Rejected: 0
    Errored: 0
    Replaced: 0
    Merged: 0
    Deleted: 0
    Mfhds created: 0
    Items created: 0

    MFHD Records
    Processed: 2
    Added: 0
    Discarded: 2
    Errored: 2
    Replaced: 0
    Deleted: 1

    Workaround

    Delete MFHDs manually in Cataloging client.


    • Article last edited: 18-Mar-2014