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