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. p_item_05: "report can not be created for more than 5000 items"

    p_item_05: "report can not be created for more than 5000 items"

    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:
    In version 19 I have had three libraries report that p_item_05 is not picking up all of the possible items when it is run. ABC50 was trying to do a shelf list of their DVD collection and it reported only 6 titles.

    PQR50 was trying to do a shelf list of missing items and had the same results. Fewer titles than should have been reported.

    Has something changed (from v17) so that p_item_05 is not working correctly?

    Resolution:
    These runs of p_item_05 are getting the following message:

    b_item_05: The report can not be created for more than 5000 items

    There are 125,000 items for abc50, so it is reading only about 4% of the items before it stops. p_item_05 reads *all* of the items in the call number range. When you specify "A – N", it is reading all of the items with call numbers in this range. When it hits 5,000 it stops.

    p_item_05 works well in the case where the call number range is relatively limited in relation to the total number of items. It does not work well in cases where there are relatively few items in the collection (item status, etc.) being specified and there's a broad call number range.

    You could break it into (roughly 25) call number pieces. Or, you could run p_ret_adm_01 (for collection DVD), setting "Build Batch Report" to "Yes" and Sort Report By to "Call Number". Unlike p_item_05 this report would include all items with the collection DVD.

    The p_item_01, _02, ... series of jobs might be another alternative.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_item_05 returning results in ASCII/decimal order instead of correct LC order
      • p_item_05: Execution error : file '/exlibris/aleph/a16_3/aleph/exe/date_x_n.gnt
    • 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