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. ue_01_z0102 process stops after 2000 records; account is locked; CTXSYS

    ue_01_z0102 process stops after 2000 records; account is locked; CTXSYS

    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: 18.01

    Problem Symptoms:
    Our version 18 ue_01_z0102 process is stopping after processing 2000 records:

    cd $data_scratch
    grep -c HANDLING *run_e_01_z0102*

    run_e_01_z0102.12005:2000
    run_e_01_z0102.14552:2000
    run_e_01_z0102.15486:2000

    There's no indication in the log of any error, but util c/1 and "ps -ef / grep z0102" show that the ue_01_z0102 process no longer exists.

    The other two ue_01 processes seem to be working fine.

    Cause:
    CTXSYS account locked.

    Resolution:
    This happens because the CTXSYS account is locked: in each of the run_e_01_z0102 logs we see this after 1000 times HANDLING:

    Oracle error: handle_connection
    ORA-28000: the account is locked

    Then, for some reason, it gets stuck the second time (another 1000 times).

    This was an upgrade problem, and did not occur again once it was fixed (unlocked).

    The fix is the following:

    s+ aleph_admin
    alter user CTXSYS identified by CTXSYS account unlock;
    exit;

    Additional Information

    If user aleph_admin doesn't have enough privilege, then use an Oracle log-in which does.

    In another case, the symptom was the same except that the message "invalid username/password" appeared after 1000 lines instead of "account is locked".

    Category: Background processing (500)

    Subject: Ue (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ue_01_z0102 keeps stopping; Segmentation fault in aleph_startup
      • ue_01_z0102 process stops after 2000 records; invalid username/password
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. Background processing (500)
      3. contype:kba
      4. Prod:Aleph
      5. Type:General
      6. Ue (500)
    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