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

Description:
Oracle error: io_z13u_write
ORA-00001: unique constraint (ABC01.Z13U_ID) violated


I am running p_manage_07 as part of a full reindex on my test system and am getting the following errors repeatedly:

ORA-00001: unique constraint (ABC01.Z13U_ID) violated

This is in preparation for an over-weekend run on production.
We're at SP 2069

Resolution:
unique constraint violated" occurs when Oracle tries to write a record with a column whose value duplicates an existing value where the Oracle index on the column is defined as Unique.

In this case, p_manage_07 is failing to drop the existing z13:

aleph_admin@ALEPHTST> 10:42:19 aleph_admin@ALEPHTST> DROP TABLE ABC01.Z13
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
This may have occurred because someone was accessing the test server z13 -- either via the www_server or the pc_server -- at the time the job was submitted.

You can just try submitting the job again. The error shown above will appear in the p_manage_07 log within 10 seconds if there's a problem.

If you find that it still doesn't work, then try stopping the www_server and pc_server prior to running it.

If that doesn't work, then perform the steps described in KB 8192-7896.

[From site:]

Thanks, I ended up dropping the two tables manually. It took 3 tries to drop z13u due to "resource busy" but it did drop successfully.

• Article last edited: 10/8/2013