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. ARC 2.0 ETL fails

    ARC 2.0 ETL fails

    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:
    The new ARC 2.0 ETL was failing with the message "p_arc_run_incremental.sh: No such file or directory". It appears that with Aleph 18 service pack item #986 a new parameter was introduced and the default set to "incremental". Why is the ETL failure occurring?

    Resolution:
    For the problems that you had with the incremental ETL, you will need to make the following changes. These should be changed in the distribution at some point, but haven't been yet.

    Changes for incremental ETL:

    Edit $aleph_proc/p_arc_01 and change line 53 (or neaby) from:
    source p_arc_run_incremental.sh
    to:
    source $aleph_proc/p_arc_run_incremental.sh

    In $aleph_proc/p_arc_run_incremental.sh, change the section below (lines 33-38) from:

    select max( to_char($arc_user.prc_process.EXTRACT_START_DATE,'YYYYMMDD' ))
    from $arc_user.prc_process
    where $arc_user.prc_process.PROCESS_END_DATE is not null
    and (select count(*) from $arc_user.prc_extract_process
    where $arc_user.prc_process.PROCESS_CODE =
    $arc_user.prc_extract_process.PROCESS_CODE) > 1;

    To this:

    select max( to_char($arc_user.prc_process.PROCESS_START_DATE,'YYYYMMDD' ))
    from $arc_user.prc_process
    where $arc_user.prc_process.PROCESS_END_DATE is not null
    and (select count(*) from $arc_user.prc_process_detail
    where $arc_user.prc_process.PROCESS_CODE =
    $arc_user.prc_process_detail.PROCESS_CODE) > 1;


    These changes should allow the incremental ETL process to run.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ARC 2.0 and Office 2007
      • ARC 3 - authors are missing the capability to use HTMLItem layout element.
    • 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