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. Acq client crashes in displaying particular order (or associated invoice)

    Acq client crashes in displaying particular order (or associated invoice)

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

    Problem Symptoms:
    Acquisitions client crashes trying to display Invoice -- or order 123456-2 which is connected to this invoice.

    Cause:
    Acq is reading the order record's z601 (budget transaction) records to display amounts committed/spent.
    A particular z601 causes the crash. {When the z601_rec_key_3 (the order number) was temporarily changed, the order and invoice displayed without problem.}

    Resolution:
    Run the following SQL to display the z601 records connected to the order:

    SQL> select Z601_REC_KEY, Z601_REC_KEY_2, Z601_ACTIVE_SUM from z601 where z601_rec_key_3 = '00012345600002' order by Z601_ACTIVE_SUM;

    {where 00012345600002 is the order key (ADM# + sequence)}.

    Examine the results to see if any seem odd/defective.

    Additional Information

    In this case the active-sum and local-sum were zero:

    SQL> select * from z601 where z601_rec_key = '3201-S-2013 201206249854629';

    3201-S-2013 201206249854629
    00000 00550163200002 Y-TOYO
    20120624 ENC

    D USD 20120624 000000000000 00000000000000 00000000000000
    00000000000000 00000000000000

    (It is normal for there to be many z601's with zero amounts; it's unclear why this particular one caused the crash.)

    Category: Acquisitions (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • acq budget with bib info
      • Acq GUI "Index List" labels not in .Acqtabxxxwindow.dat
    • Was this article helpful?

    Recommended articles

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