Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    p_item_01: Oracle error: io_z30h_write; Failed to allocate Shelf Report Number

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

    Description:
    We have not been successful in running item_01 without call number parameters. I expected 33 items records would meet the selection criteria:

    SQL-ABC50> select count(*) from z30 where z30_sub_library = 'TFOR' and z30_collection = 'OFC';
    COUNT(*)
    ----------
    33

    We received more than 25,000 repetitions of the following error before I stopped the job:

    Oracle error: io_z30h_write
    ORA-00001: unique constraint (ABC50.Z30H_ID) violated

    Please advise.

    Resolution:
    The p_item_01 log file has error: "Failed to allocate Shelf Report Number".

    You need to add "last-shelf-rpt-num" to z52 in ADM library like this (do not include the arrows):

    > util g/2

    Enter sequence number to update,
    or return to continue, or NEW to create new sequence, or 0 to exit: NEW <------

    Enter sequence name (lower case): last-shelf-rpt-num <-----

    Enter sequence start number: 0 <-----

    Enter prefix for format output: [leave blank]

    Do you want to supress leading zeros in format output (y/n): Y <-----

    Enter type (S/U): S <-----

    • Article last edited: 10/8/2013