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

    v20 Acq client hangs during invoice operations; "user break" frees it

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

    Description:
    We are not seeing any obvious errors in the logs, but system keeps hanging during invoice operations. If we stop it from processing, it successfully completes the task and we can move on, otherwise it spins and spins.

    The hanging seems to occur with any activity related to general invoices. It happens in the following scenarios:

    Search in invoice bar by vendor and invoice number for existing invoice.
    Edit existing general invoice.
    Navigate from line item to general invoice.
    Navigate from general invoice or line item to invoice payment log.
    Edit existing line item.
    Add new line item.
    Creating a new invoice from the invoice search bar (after you agree to create).
    Deleting a line item: the line item disappears immediately but the processing display in the lower left continues to be active until you interrupt it.

    Adding a new invoice from the order tab is OK. Editing it in the invoice tab produces the hang.
    Going from the invoice payment log back to the general invoice or the line item is OK.
    Going from the general invoice to a line item is OK.
    Refreshing the screen for a general invoice as you edit is OK.

    In any of the scenarios, I can stop the process by clicking the "processing" area in the lower left corner, which generates the message "User break." In every case so far, the system successfully completes the task I was trying to do.

    Resolution:
    Checking the abc50 z71 with util a/17/14, I see this:

    Enter Table Name : z71

    Defined in file_list:
    __________________________________________________________
    IND z71_id 200m 4431 ts_abc50_mediumx
    IND z71_id2 4M 0K TS2X
    IND z71_id3 4M 0K ts_abc50_mediumx
    __________________________________________________________


    Exist in the Database:

    INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
    --------------- ------- ---------- ----------- --------------------
    Z71_ID VALID NORMAL UNIQUE Z71_REC_KEY


    The z71_id2 and z71_id3 Oracle indexes do not exist. As noted elsewhere, the absence of Oracle indexes can cause severe slowness in reading the tables which the index accesses.

    You need to do util a/17/2 to build these indexes.

    I suggest you perform the SQL in KB 8192-6423 to look for other cases where Oracle indexes are missing.

    • Article last edited: 10/8/2013