p_item_01: z30_shelf_report_number/z30_inventory_number; "e: Event not found"

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20, 21, 22, 23

Description:
I have read through section 7 (Inventory Management) of the Items documentation and have many questions about how this process works. To begin with, I am trying to run item-01 as the first step in marking a subset of items for inventory. I am working in our test environment. Specifically these items are in Hodges Library (sublibrary H), in the Juvenile collection (JUV). The call number range is FA129fi through FZ9458s.

I ran item-01 twice but could not tell from the output report or the job's logfile whether anything was updated. I did some checking in SQL (looking at z30_inventory_number and z30_inventory_number_date), but it seems that nothing was updated for today's date.

Next I tried running item-01 again, using the z30_call_no_key fields for the call number start/end ranges. Now it seems that the item-01 job no longer runs at all. There is no evidence of my past two attempts appearing in the Batch Log of the Admin tab, even though the logfiles appear in /alephe/scratch. It appears there is a problem as the logfile ends with "e: Event not found", but I'm not certain what that means.

[More:]

Our staff wish to do a "real-time" physical inventory of the Juvenile fiction collection, which contains about 9,000+ items. They want to scan each book barcode-by-barcode, placing those that are misshelved on a book truck to reshelve later. They also want the capacity of the system to recognize when an item is checked out, in processing, etc. Of course, this process/workflow would need to be able to run over the course of several days/weeks given that 9000 items could not possibly be done at one sitting.

I think what we want in our case is p_item_01 (and the additional services item-07, item-08, item-09, item-10). But I cannot seem to get item-01 working properly.

Resolution:
[To customer:]

The logged error message "e: Event not found" is most likely occurring because p-item-01 is failing to update the Z30-INVENTORY-NUMBER in your selected subset. This is because the required inventory-number parameter in util g/2 (Z52) is not currently populated with a counter value.

While comparing util/g/2 values in abc50 with the util/g/2 values in the demo ADM (usm50) I noticed that abc50’s util/g/2 settings currently do not include an inventory-number counter value.

Knowledge base item #16384-15076 details how the Z30-INVENTORY-NUMBER is populated in util/g/2 (Z52) via settings in tab100. Reviewing your current abc50/tab/tab100 settings, I have confirmed that the necessary Z52 parameters are currently not configured. In order to resolve the reported p-item-01 issues, values will need to be assigned to the Z52 parameters “inventory number (1)” and “inventory number (2)” in tab100.

Please refer to Knowledge base item #16384-32577: “Populating z30_inventory_number with counter value from util g/2 (Z52)” for detailed instructions on how to assign/configure these values. Because “inventory number (2)” is not essential to the performance of p-item-01 a value of “0” may be assigned, if desired.

Once your tab100 settings are in place please re-reun p-item-01 to see if the reported "e: Event not found" error message or other anomolies persist.

[From Customer:]

I have read section 7 of the Items Staff User Guide (Inventory Management) and have several questions about the process :

To start with, does item-01 update both the Z30_SHELF_REPORT_NUMBER and the Z30_INVENTORY_NUMBER (along with Z30_INVENTORY_NUMBER_DATE)?

Last Friday afternoon I added a new counter in util/g/2 for last-shelf-rpt-num and re-ran item-01. This time the service did not end with an error but seemed to run completely. I confirmed that new numbers were being written in Z30_SHELF_REPORT_NUMBER for the defined subset. However, no new inventory numbers were created.

At your suggestion, today I edited tab100 in abc50 by adding the following line:
INVENTORY-NUMBER=Z52

Then I added a new counter in util/g/2:
z30-inventory-number 1000 Y S i

I ran item-01 again for my defined subset and did not see any new inventory numbers created. Also, I used the Inventory Marking tool over the appropriate Shelf Report number to scan a few barcodes. However, this didn't create new inventory numbers or dates on the items either.

How are inventory numbers and inventory number dates generated?

[To customer:]

Please see this PowerPoint presentation entitled "How To Use Inventory Management" which discusses the p-item-nn services and their workflows: : /@api/deki/files/47630/How_to_use_Inventory_Management_(1).ppt in the Cataloging section: How to use Inventory Management .)

(Found at that this doc can be found at https://knowledge.exlibrisgroup.com/Aleph/Product_Documentation/How_To_Documents/Additional_How_To_Presentations_from_Support .)

The Z30-SHELF-REPORT-NUMBER is assigned by p_item_01, using the xxx50 z52 (util g/2) last-shelf-rpt-num counter. If there is no last-shelf-rpt-num parameter, then no Z30-SHELF-REPORT-NUMBER is assigned.

Regarding the Z30_INVENTORY_NUMBER: While your reported settings in util/g/2 (z52) appear to be correct and should populate the Z30_INVENTORY_NUMBER with the unique number via p-item-01:

Sequence Name Value Suppress Type Prefix
------------------------------- --------- ---------------- -------- --------------------
z30-inventory-number 1000 Y S i

It is also noted in Knowledge Base item 16384-15076 that: "(The) Z30-INVENTORY-NUMBER is always assigned by using the Oracle table Z311 and the ALEPH table ./xxx50/tab/tab_z311."

Page 9 of the System Librarian's Guide for Items verifies this: "tab_z311 is used to define the z311 programs used by the system for the creation of the Z311 counters for the z30-call-no, z30-call-no-2 and z30-inventory-number fields."

The following is a sample of the table:

! 1 2 3
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!!!!!-!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
z30-call-no 0 create_z30_location_i
z30-call-no-2 0 create_z30_location_i
z30-inventory-number 1 create_z30_inv_number <--------------------------

In order to create a Z30-INVENTORY-NUMBER as requested, it is my understanding that you will need to update /exlibris/aleph/u20_1/abc50/tab/tab_z311. Currently the line "create_z30_inv_number" is commented out. If possible, please uncomment this line and re-test p-item-01, I believe this should resolve the problem.

! 1 2 3
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!!!!!-!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
z30-call-no 0 create_z30_location_i
z30-call-no-2 0 create_z30_location_i
!z30-inventory-number 1 create_z30_inv_number <---------------------------

See paragraph on Z30_INVENTORY_NUMBER_DATE in section 4 of KB 16384-15076.

Article last edited: 10/8/2013