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

    No z36h.seqaa file created by file-03 run for z36h

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    Though file-03 ("Export Database Tables") for the xxx50 z36h (Loan history) table seems to complete successfully and no errors appear in the $alephe_scratch log, no ./xxx50/files/z36h.seqaa file is created.

    Cause:
    The following SQL shows that the count of xxx50 z36h records is zero:

    xxx50@ALEPH21> select count(*) from z36h;
    **** Hit return to continue ****

    COUNT(*)
    ----------
    0

    And the ./xxx50/tab/tab100 has the following setting:

    CREATE-Z36H=N

    Resolution:
    If history records are desired for future loan transactions, set CREATE-Z36H=Y. {There is no way to have z36h records be created for past loan transactions -- though there' *is* a z35 (Event) record for each loan transaction, which has some of the same information as the z36h.}

    Category: Circulation (500)

    • Article last edited: 5/12/2014