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

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

    • 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