Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Missing "Deleted" item history record for certain deleted items

    Missing "Deleted" item history record for certain deleted items

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    An item record no longer exists, but there is no deleted Z30H (Item History) record for it.

    There are other item history entries for the item, but none with z30h_h_reason = 'Deleted'.

    Cause:
    1. Has the tab_item_history.eng table always been configured to record DELETE events?

    2. Was the item temporarily created and immediately deleted by p_manage_50 when that service is only building an HOL. ( This leaves behind an item history record, but not one that says Deleted.)

    3. Is this a Deleted (Bound) item? The program was not creating a z30h record for these item-processing-status BD items.

    Resolution:
    1. Check the version of ./xxx50/tab/tab_item_history.eng for the time period when the item seemed to disappear to determine if the table has a line with "DELETE" in column 1 ("Field changed or action that causes history").

    2. Check for p_manage_50 runs building an HOL only around the time of the item's disappearance.

    3. Implement v21 rep_change 2325 (v22 rep_ver 19055). It allows z30h records to be created for item-processing-status "BD" items.

    Additional Information

    Run the following SQL in the ADM library to locate cases where an item has been deleted but there is no z30h Deleted record:

    SQL> select unique substr (z30h_rec_key,1,15) from z30h minus select z30_rec_key from z30 minus select substr (z30h_rec_key,1,15) from z30h where z30h_h_reason = 'Deleted';

    Category: Cataloging (500)

    Subject: Items (500)


    • Article last edited: 4/16/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Missing 'Get Order' search choice
      • missing ALEPH sublibrary in local patron information
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Cataloging (500)
      3. contype:kba
      4. Items (500)
      5. Prod:Aleph
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved