p_arc_01: 226 671 ORA-00001: unique constraint (.) violated
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We get the following error when trying to run p_arc_01 - ./abc50/scratch/p_arc_01_transform.log :
FINISHED FINISHED 317 tasks of 360
1 row selected.
PROCESS_CODE TASK_CODE ERROR_MESSAGE
226 671
ORA-00001: unique constraint (.) violated
226 671
ORA-00001: unique constraint (.) violated
Can you advise, it seems the data transfer to arc is incomplete?
Resolution:
The error occurs due a duplicate entry in pc_tab_exp_field.lng. Even though the error appeared, the ETL process did end fully and all the data exists.
For example, a site had:
P-ACQ-02-01 L Invoice status 044
P-ACQ-02-01 L Invoice status 044
Deleting the second occurrance corrected the unique constraint violated.
In another case the site had the following lines for ACQ_ARRIVAL_STATUS (some with underline, others with hyphen -- both are accepted):
>>grep ^ACQ.ARRIVAL.STATUS pc_tab_exp_field.eng
ACQ_ARRIVAL_STATUS L Komplet CMP
ACQ_ARRIVAL_STATUS L Delvis PTL
ACQ-ARRIVAL-STATUS L Komplet C
ACQ-ARRIVAL-STATUS L Delvis P
Therefore, there is a duplicate entry for Komplet and for Delvis. This duplicate entry causes the error messages.
Please correct your pc_tab_exp_field files so that only one entry for each arrival status will exists, and the ETL process should have no more errors.
- Article last edited: 10/8/2013