Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. p_arc_01: 226 671 ORA-00001: unique constraint (.) violated

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_arc_01 stuck at cycle 1 in p_arc_01.cycles
      • p_arc_01: "Error 5001 Not defined for service in file p_arc_01"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved