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. Due date of 1/19/2038

    Due date of 1/19/2038

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

    Description:
    At one of our sublibraries all check-outs and renews for a specific patron type are generating with the due date of 1/19/2038. All other sublibraries and patron types are generating the correct due date.

    This situation appears to have started this weekend.

    Resolution:
    Checking with SQL:

    abc50@ABCPRD> select z36_rec_key, z36_sub_library, z36_item_status, z36_bor_status from z36 where z36_due_date like '2038%';

    I find that the cases where the due year is 2038 are all sublibrary ABCMU, item status 01, patron status 30.

    Looking at the z301 for ABCMU with util f/4, we see:

    02 z301_line[000000005]..0130+0000011220380119A23592359+0000001420110922A23592359

    As described in the z301.pdf document,

    the Z301-PAR-DATE is 00000112 and
    the Z301-DUE-DATE is 20380119

    Today + 112 is January 3, 2012, so the program is looking in tab17 ABCMU section for the first day that the library is open on or after Jan. 03, 2012. Since all the tab17 ABCMU entries begin with "2011" as the year, it is unable to find any such day.

    You need to either add "2012####" lines or -- better -- change the "2011####" lines to "########", and then either run p_cir_01 or do util a/17/1 for the abc50 z301 (-- make sure you do z301 and not any other table!).

    The need for "########" lines for *every* tab17 GroupID is described in KB 16384-4164. (In the past the lack of an open day would cause the pc_server to loop. It seems that the program has been changed to stop at some point -- such as 26 years!)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Due date is same as check out date
      • Due dates for recalled items incorrect or display incorrectly; due_date_format 4
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. 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