io_z308 ... unique constraint violated due to lowercase characters

• Article Type: General
• Product: Aleph
• Product Version: 20

Problem Symptoms:
When trying to update patron barcodes (or other z308 ID's) with new values using file-20 (Patron Loader), the following Oracle message appears in the logfile:

io_z308 routine failed while trying to WRITE.
Oracle error: io_z308_write --- ORA-00001: unique constraint (ABC00.Z308_ID) violated

Cause:
Lowercase data in the Z308-KEY-DATA fields

Resolution:
Change the z308-section in the PLIF-input-file to all uppercase

In Aleph the Z308-KEY-DATA is always in uppercase.

Before Example:
<record-action>I</record-action>
<z308-key-type>01</z308-key-type>
<z308-key-data>newbar1</z308-key-data> <------------------Lowercase
<z308-user-library>XXX50</z308-user-library>
<z308-verification>19800101</z308-verification>
<z308-verification-type>00</z308-verification-type>
<z308-status>AC</z308-status>
<z308-encryption>H</z308-encryption>
</z308>

After Example:
<record-action>I</record-action>
<z308-key-type>01</z308-key-type>
<z308-key-data>NEWBAR1</z308-key-data> <---------------------------- Uppercase
<z308-user-library>XXX50</z308-user-library>
<z308-verification>NEWBAR1</z308-verification>
<z308-verification-type>00</z308-verification-type>
<z308-status>AC</z308-status>
<z308-encryption>H</z308-encryption>
</z308>