Symptoms

• Magnetic media & sensitize flags for item records store Y as 1 in database when the item is updated, created or resaved in Circulation.
• Voyager sends 1 instead of Y in self-check responses

Defect Status

Issue VYG-6736 is resolved in Voyager 9.2.1.

Replication Steps

1. Identify an item record where ITEM.MAGNETIC_MEDIA=Y and/or ITEM.SENSITIZE=Y

select item_id
,magnetic_media
,sensitize
from item
where item_id=NNNN;

ITEM_ID M S
---------- - -
NNNN N Y

2. Circulation > Item > open item record
3. Item > Edit item ...
4. Click OK
5. View flags in database again:

ITEM_ID M S
---------- - -
NNNN N 1

6. Open item in Cataloging. Note that flag that had been Y and is now 1 is no longer checked.
7. Click Save to DB. Flag is now N in database:

ITEM_ID M S
---------- - -
NNNN N N

8. Check the checkbox and click Save to DB:

ITEM_ID M S
---------- - -
NNNN N Y

9. Circulation > Item > Edit item ...
10. Click OK:

ITEM_ID M S
---------- - -
NNNN N 1

11. Circulation > Pick and Scan > select a change to make > use item_id or item_barcode and Update Database to update record:

ITEM_ID M S
---------- - -
NNNN N Y

Workaround

Option 1: Use Cataloging and Pick and Scan to update/create item records.

Option 2: Manually update flag in Cataloging.

Option 3: Use Pick and Scan to update Magnetic media & Sensitize flags for impacted item records:

1. Identify two lists of item_id numbers: one where sensitize is impacted and another where magnetic_media is impacted.

select item_id
from item
where sensitize='1';

and

select item_id
from item
where magnetic_media='1';

2. Use Pick and Scan to set Sensitize or Magnetic Media flag to Yes in Changes to Make tab, as appropriate.
3. Select list of item_id numbers for the corresponding flag in Records to Change and Update Database.

Article last edited: 17-May-2016