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. Z67-SEQUENCE reaching limit of 9999

    Z67-SEQUENCE reaching limit of 9999

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    Multiple sites have found that certain Z67-USER's have hit the limit of 9999 in their Z67-SEQUENCE. Both noticed substantial gaps in the numbering. In U. Minn's case, these gaps amounted to about 50% of the numbers for the problem user (TMACPR03). Two gaps were about 1000 each. In both cases they have had to renumber the Z67-SEQUENCE's in order to reduce the high sequence from 9999.

    I posted a question to the ELUNA SysAdmin list about this.

    Christine Moulen at MIT wrote:

    In considering increasing the max for a future version, don't forget that version 19 has a lot more privileges.

    In version 18, the max in my database is 306. In version 19, it jumped to 1333.
    That's just by running the upgrade kit, I haven't done much assignment of new privileges yet. We also have very few sublib-specific permissions assigned.

    I don't see large gaps in the 1333, but there are a lot of small gaps in there.


    CCLA has also found gaps in sequences. Jeannie Dixon wrote:

    CCLA has had this problem as well. We haven't yet hit the 9999 on any non-administrative patron IDs but we have had problems with any ID that had a lot of permissions or gaps in sequences. They could not be retrieved in the client. Our DBA had to renumber all of the permissions for those with gaps.

    Resolution:
    The Staff Privileges User Guide includes a full list of the existing privileges. The expand in size is due to the regrouping, which results in expanding ‘All subfunctions’ in many cases where the old group’s privileges got scattered across many new groups.

    Since in some cases a staff user had many permissions and there were gaps in the sequence numbers, we have added a program which removes the gaps.

    This program can be run using the following commands:

    cd upgrade_express_1801_1901/source/1001
    perl remove_holes.pl


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Z67 not created when using a proxy
      • z68_arrival_status = "C" (complete) showing in Gui Acq as "Non Arrived".
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 19.01
      2. contype:kba
      3. Prod:Aleph
      4. 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