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

    ADM record accidentally deleted and ACQ Order says bib not found


    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care



    Somehow one of the librarians deleted the ADM record on an order! The bib is still in the system, and the z68 table thinks it is still linked. But in ACQ you get the error about the bib not found. How do we get this fixed?

    Title : Patient privacy, consent, and identity management in health information exchange
    Order# : 106422
    Previous Bib# : 002277778

    She actually was trying to move it from bib 002277778 to bib 002808637 when she did this.


    We see in util f/3/12 that xxx01 bib 002277778 is connected to xxx50 ADM 025997107, a new ADM record which has been created. 
    And (in util f/4) that ADM doc record 002277778 is (logically) deleted.  (It has a "DEL Y" field.) 
    We see that there are z68, z601, z75, z78, and z71 records with 00227777800001 in them. 
    Rather than changing these, the best thing would be to use SQL to change the doc number of this xxx50 ADM 025997107 record to 002277778. 
    The steps are these: 
       > s+ xxx50 
       SQL> delete from z00 where z00_doc_number = '002277778'; 
       SQL> update z00 set z00_doc_number = '002277778' where z00_doc_number = '025997107'; 

    And, assuming the above goes OK, then: 
       SQL> commit; 
    Then your staff person should be able to move the order as she was trying to originally. 
    As a precaution, you should use the file-03 GUI Service to back up the xxx50 z00 table before doing the above. 



    • Article last edited: 1-Sep-2017