Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    CIRC/patron SIF:number of Characters in City Inconsistent Across Client

    • Article Type: General
    • Product: Voyager
    • Product Version: 7.2.2

    Problem Symptoms:
    1. City field in Patron SIF has more than 30 characters.
    2. The following error is in the log.pupd:
    Record Add failure in table "patron_address". Patron ID: 451
    SQL Error Code: -1480

    Cause:
    This behavior is the result of Issue 16384-15777

    Resolution:
    Issue 16384-15777 is currently in Development.

    Additional Information

    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.

    Category: Circulation


    • Article last edited: 10/8/2013