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

    Batch jobs which add/update HOL records stall

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    Though their log files don?t show any errors, jobs which add/update HOL records {such as, manage-18 (Load Doc Records), manage-21 (Global Change), and manage-37 (Fix Catalog Records)} stall.

    The log shows that the job stops immediately upon reading the first record:
    1 START READING AT hh:mm:ss

    Even after an hour, nothing additional has happened.

    Cause:
    Uncertain. Possibly, Oracle deadlock.

    Resolution:
    Stopping/restarting Oracle corrected the problem.

    Additional Information

    Diagnosis:
    1. Try running a different job which updates HOL records to see if it has the same problem.
    2. If so, run aleph_shutdown, stop/restart Oracle, run aleph_startup; stop the xx60 ue_01; then try the jobs again.

    See also Article 000019284 (KB 16384-3416) (?p_manage_18; record deletion; "resource busy and acquire with NOWAIT specified").


    • Article last edited: 2/10/2014