Problem Symptoms

• City field in Patron SIF has more than 30 characters.
• The following error is in the log.pupd:

Record Add failure in table "patron_address". Patron ID: 451
SQL Error Code: -1480

Defect Status

Issue 16384-15777/VYG-4523 is resolved in Voyager 8.2.0

Replication steps

1. Find the patron in your db that has the lowest patron_id.
2. Update this patron to have an address of 20 characters.
3. Run a patron extract to create a patron SIF for the first patron in your db (Pptrnextr ?r1).
4. Go to the SIF (which will live in /rpt) and edit the record such that
a) The first segment is zero-filled (ten characters)
b) The SSN and IID are unique to this db
c) You replace the first 10 of the last blanks in the City segment with 10 more characters
5. Run patron update using this SIF (Pptrnupdt ?p /m1/voyager/yyydb/rpt/[name of SIF file]
6. You?ll see that this patron is successfully added as new.
7. Go back to that same SIF and edit the record such that
a) The final 10 blanks in the City segment are filled
b) The SSN and IID are newly unique
8. Run patron update using this SIF (Pptrnupdt ?p /m1/voyager/yyydb/rpt/[name of SIF file]
9. This time you?ll see that the record errored out.
10. Go to the log.pupd in /rpt for this most recent run.
11. You?ll see this message:
Record Add failure in table "patron_address". Patron ID: 451
SQL Error Code: -1480

Workaround

Only use the first 30 characters of the City field.

• Article last edited: 08-Oct-2013