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

    ORA-01405 error when running Acq Open Orders Report

    • Article Type: General
    • Product: Voyager
    • Product Version: 8.2.1

    Problem Symptoms:
    ?€¢ When Open Orders Report is run, receive error in acqjob.log:
    Failure to retrieve bib title.
    SQL Error: ORA-01405: fetched column value is NULL
    PO Number: 4331
    Title:
    Line Item #: 1
    System Keys: (copyid 5633)
    (lineitem 5679)
    (bib 111872)
    (po 4331)

    Cause:
    Bib record referenced does not contain a 245 (title) field.

    Resolution:
    1. In Cataloging, add title in 245 field of bib record.
    2. Run acqjob again.

    Category: Acquisitions


    • Article last edited: 10/8/2013