• 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