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

• 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