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

    Item/order creation for new bib record times out

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Creation of the first item or order for a new bib record is increasingly slow -- it now frequently times out with "Server failed to execute request after 60 seconds". And the "io wait" percentage in the "top" command is in the 20-40% range (while it had previously been 0-5%).

    Resolution:
    This slowness was traced to the writing of Z00R records in the xxx50 (as part of the creation of the Z00/doc record).

    While the xxx50 $data_tab/tab100 had "CREATE-Z00R=Y" and the SQL "desc z00r" showed that the z00r existed in the xxx50,

    * util a/17/11/2 was getting the message, "the z00r is not managed by xxx50";
    * util f/4 was getting "error in z00r"; and
    * SQL "select count(*) from z00r" or "select * from z00r where z00r_doc_number = 'nnnnnnnnn'" took forever.

    It seems that the sequence leading to this must have been something like this:

    * z00r was in the file list, resulting in the z00r being created in Oracle by the initial util a/17/1 all;

    * z00r was removed from the file list, but the z00r table was not dropped in Oracle;

    * the z00r_id Oracle index was lost at some point;

    * "CREATE-Z00R=N" was changed to "CREATE-Z00R=Y".


    There are two possible solutions:

    1. Change "CREATE-Z00R=Y" to "CREATE-Z00R=N" and do SQL "drop table z00r" ... in the *xxx50*!

    2. Leave "CREATE-Z00R=Y" as is; add z00r to the xxx50 file list; run util a/17/2 to generate the z00r_id Oracle index.

    Additional Information

    faq


    • Article last edited: 10/8/2013