io_z34_write, unique constraint (ABC50.Z34_ID) violated

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

Description:
You are getting hundreds of

Oracle error: io_z34_write
ORA-00001: unique constraint (UDQ50.Z34_ID) violated

messages in the www_server log. [ <Jerry Specht > ]

Resolution:
Looking at Article 000013400, I did:

abc50@ALEPH0> select count(*) from z34;
**** Hit return to continue ****

COUNT(*)
----------
9999994

Per Articles 000013400 and 000004879 ("When are z34's written? z34 vs. z69"), you don't need the z34. We suggest that in $alephe_root/www_server.conf you change

create_statistics Y

to
create_statistics N

(The same change can and should be made in the $alephe_root/pc_server_defaults.)

• Article last edited: 2/13/2015