Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    p_arc_01: 226 671 ORA-00001: unique constraint (.) violated

    1. Last updated
    2. Save as PDF
    • 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